I have been working on a database for an online webstore, the store will have various types of products, like computers, printers, cameras, etc..
I have set up a main table
Now since I need to have details for each one of the items, like computers for example would need to have specific details for computers and printers need to have specific details for printers, I created a details table for each:
As can see everything is linked by ProdID that way I can look up the details for each of the products depending on what it is, that is determined by the AssetType in the product table.
My question is, is this a good way to do it? I am going to have various other items and this would mean that I would need to create details tables for each one of those.
I was also contemplating creating one big details tables and include all the fields for all the different items and then create views for each one of the different types of items.
If anyone can help me out, it would be greatly appreciated.