Database Table Design Suggestions?

A

admin

Administrator
Staff member
I've got to store some product information for many different types of products (ie., guitars, drums, keys). Many of the fields are needed for all (ie., Manufacturer, Account number, etc.), but some are specific to the product type. For example, for guitars need to know nylon or steel strings, but that doesn't make sense for drums or keys. I don't think it makes sense to put all of the fields in one table and only use the ones needed. Maybe, I should have a table tblGeneralProductInfo which is linked from specific tables tblGuitarProducts, tblDrumProducts, and tblKeyProducts.

Any suggestions?

Thanks,
Michael Bunger
 
You must log in or register to reply here.
Back
Top