0

Lets say you want to create a database for a store which sells different products.

Products share certain attributes like name, description and price but every product has its own unique characteristics which doesn't share with other products. For example a book has "number of pages" but a computer has "storage capacity".

Lets say we will have comments on every product from users and we want to upload attachments for every product like images and videos.

How would you design this requirements in a relational database?

If more than one design is possible, can you please highlight why would you go for one and not the other?

Sul Aga
  • 6,142
  • 5
  • 25
  • 37
  • Stay calm and use Table Inheritance – Neil McGuigan Jan 01 '14 at 18:18
  • See also my answer regarding product catalogs particularly: http://stackoverflow.com/questions/17231834/if-eav-is-evil-what-to-use-for-dynamic-values/17233204#17233204 – Joel Brown Jan 01 '14 at 19:09
  • thank you for your comments. Here is a good article I found: http://www.sqlteam.com/article/implementing-table-inheritance-in-sql-server – Sul Aga Jan 04 '14 at 10:21

0 Answers0