[Phplib-users] OT: Database Design Help

[Bob B. <bo...@iN...>]

Hi --

My apologies for an OT subject, but I figured this group of people was the 
most logical place to seek help ...

I'm setting up a database with the following parameters:
	2500 products
	11 main categories
	88 subcategories
Each subcategory belongs to a single category, and each product belongs to 
several subcategories ...

... and I can't wrap my head around the best layout.  Searching by name, 
product number, keywords, etc., is trivial, but I will need to search for 
and group products on the following terms:
	by category
	by subcategory

How do I normalize this data ...?

Thanks --

Bob.