Comment by LunaSea

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.