3 ms·
This is one of my favourite interview questions to ask: "You have an online shop with products that have some common attributes but each category of products a
by LunaSea 2y ago
This is one of my favourite interview questions to ask:
"You have an online shop with products that have some common attributes but each category of products also has it's specific attributes.
How would you model this in your code and database?"
The question is a bit more interesting if the database is relational.
Lots of answers exist, all with some trade-offs.
- t-writescode 2y agoHonestly, this sounds like a super fun question for all involved. Gets someone thinking, there isn't a right answer (well, no perfect answer), and the back and forth conversation is instructive on how they'll work as a teammate in projects.
- deleted 2y ago[deleted]
- betweentwotests 2y agoThis is exactly what I ask for in my interviews for backend engineers. I had good success filtering for backend engineers who view database as a part of the business logic rather than purely just a storage. The “answer” to the question has many variables with no right solution, so it’s also an opportunity to assess the candidate’s communication skills and how they tackle uncertainty.