Results 1 to 12 of 12

Thread: ERD Opinion

  1. #1
    Join Date
    Nov 2004
    Posts
    25

    ERD Opinion

    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

  2. #2
    Join Date
    Nov 2004
    Posts
    25
    I updated it to: http://imagebin.org/3505

    Please have a look and provide feeback.

  3. #3
    Join Date
    Sep 2005
    Posts
    22
    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

  4. #4
    Join Date
    Nov 2004
    Posts
    25
    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?

  5. #5
    Join Date
    Nov 2004
    Posts
    25

    updated

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

  6. #6
    Join Date
    Nov 2004
    Posts
    25

    updated again


  7. #7
    Join Date
    Sep 2005
    Posts
    22
    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

  8. #8
    Join Date
    Nov 2004
    Posts
    25

    B jarvis

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

  9. #9
    Join Date
    Sep 2005
    Posts
    22
    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.

  10. #10
    Join Date
    Nov 2004
    Posts
    25
    quantified, as in have their own tables?

  11. #11
    Join Date
    Oct 2005
    Posts
    1
    What software was used to generate the nice diagrams?

  12. #12
    Join Date
    Sep 2005
    Posts
    22
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •