Newbie Design Question

Helping a friend with a legacy e-commerce site, and will be using asp/ms-sql on existing server. Goal is to make site search-capable with stored procedures for preset queries.

If one part number fits different cars (for instance), is this the way one would design the product related tables?

tables.product
product_id (pk)
product_title
product_description
product_image_thumbnail
product_image_fullsize
product_price
product_fitment

tables.fitment
fitment_id (pk)
product_id (fk)
vehicle_make
vehicle_model
vehicle_aspiration

If so, what would be the correct way to query for product information for a particular vehicle make/model/aspiration?

Thanks!
ben

http://forums.devshed.com/showthrea...&threadid=89151
http://forums.devshed.com/showthrea...&threadid=36096
http://forums.devshed.com/showthrea...&threadid=62542

These are some forums that might help you