Hello,

Screenshot: http://imagebin.org/3504

Im trying to normalise my tables. ive come up with the screenshot (mentioned above). Ive gone from design #1 to design #2.

Any suggestions for improvements will be much appreciated.

Furthermore, Im finding it much more convenient having design #1 instead of #2 (i.e. less tables, less confusion).

Regards,

Krz

I updated it to: http://imagebin.org/3505

Please have a look and provide feeback.

1 Why is the company id in product?
the link company to product is 1-M or M-M
If it is M-M here should be a link table company-product

2 Shouldn't beverage be the details of a particular product?
Hence why is company in beverage and why does beverage have a
key different to its product id?

3 A company can have more than one address and phone number.

4 You should investigate those text fields.


Hope this helps.
Bill

B Jarvis,

compID is in the products table as a foreign key, because one company manufactures/has many products.

Relationship:
compID 1:M product
product 1:1 beverage
product 1:1 food

Beverage can be wines, sparkling and natural mineral water, juice, etc.
Food can be salami, cheese, spaghetti, etc.

What do you think?

I now updated it to: http://imagebin.org/3509

updated to: http://imagebin.org/3513

About the company and addresses
I was thinking that a company will have at least
a mail address (PO Box)
and a street address
and may have a separate warehouse address

Otherwise the company part is looking better

Really it is hard to say much about it because
what is stored in the lists depends on how it is to be used

how else can I improve my products, food and beverage table?

1 text is very indeterminate:
64k to say something that could be said in a couple of lines.
Consider what is going to go into those fields.

2 important information should be quantified (alcoholic content,warnings etc).

3 some of the fields for beverage apply to food as well.

quantified, as in have their own tables?

What software was used to generate the nice diagrams?

No rather as in field alcoholic-content value 45 as in 45% by volume etc.

This way you have something you can set limits on.

Text has to be searched.

Bill