Categories & Subcategories for ecommerce database
Posted on 2007-04-03
Hi database experts,
I need a little hand-holding here. I am designing a SQL Server 2005 database for an online store and I'm struggling with my Products & Categories tables design and how everything should work together.
I have a Products table with a sampling of columns show here
I need help here with linking this all together. It's easy that the "Products Table and the Category Table get linked together. But what about subcategories A category/subcategory sample would be like so:
Filter Inserts= SubCat
My question is this: should each subcategory be related to the main Category in the database? IOW, when someone enters a new "Products" record, selecting a Category of "Electronics", is there a way to restrict him only to relevant subcategories of "Chips, Modules, or Tuners"?
I hope I am making myself clear. The categories and subcategories will be used as linking navigation in the final website.