Subject: Structure

Question: How the structure of a multi price database table should look like?
Say I have a table that has products, veg and fruits, they are sold by weight, the weight
is fixed to 1 lb 2lb and 5lb and price depends on which item and the amount it weights.

I have a category table, I have a products table that has the products id, the category_id,
productName, productDescription, and image which just holds the name of the image.

I don't think I should add prices to the product table and yet I am not sure if I should make a
separate table for prices price1 price2 price3 and then another table for weight b1, lb2 lb3.

Should I make a table for price1 and lb1 and another table for price2 and lb2 and another table
for price3 and lb3.

So so confused...

Any help is so greatly appreciated....

Lisa
B. Barry says the Things of Interest are :-
1. Prices
2. Products
3. Others to be determined

C. The Business Rules are as follows :-
1. To be determined.



 © DataBase Answers Ltd. 2011