The pseudo data doesn't help me much. I don't see why you don't just have 1 table for category and 1 table with product and the category primary key is in the product table as a foreign key value. Not sure if that will make sense to you. Perhaps some info on normalization
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com...on-part-i.html
and/or
http://holowczak.com/database-normalization/
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.