I have 2 question on designing DB with MS-SQL 2005.
1. I am trying to create few database table for products.
I am stuck on how to copy same product to multiple sub categories.
For Example, what do I do if I want to display ProductID 001 to subcategoryID AAA and subcateogry BBB ?
These are the samples of my tables
2. With above db, I can't create other subcateogry under subcategory. If I wanted to have more categories under subcategories, How should I design the DB?