Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2010
    Posts
    4

    Question A little ERD help

    I just wanted to see if someone would review my ERD to make that I have my relationships correct. If not please point me in the right direction as I am new to database design and want to make sure that I am on the right track. Thank you for viewing my post.


    ERD02.doc

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    your employee-employeetype relationship has the FK on the wrong side

    i think this error is also repeated in other relationships
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2010
    Posts
    4
    Ok thanks for looking at my post and offering help I will make thee necessary corrections and repost my results. Again thank you

  4. #4
    Join Date
    Nov 2010
    Posts
    4
    ERD02.doc
    Ok here is my revised ERD but still not sure if I have gotten this correct yet. Also wouldn't Deliveries and Customer be a 1:1 relationship?
    Last edited by Cbick; 11-05-10 at 13:37. Reason: forgot attachment

  5. #5
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Only if you only want to deliver to a customer once. Wouldn't you want to keep a customer and continue to sell items to them over and over again. I did not look at your diagram.

    Dave

  6. #6
    Join Date
    Nov 2010
    Posts
    4
    Thanks Dave for anwsering my question. I thought thats how it should be but I wasnt sure. Thanks for the clarification.

    Edit: I am still trying to figure this out and have made a few more changes to my ERD.
    Here is my updated ERD: ERD02.doc
    Last edited by Cbick; 11-05-10 at 14:49.

Tags for this Thread

Posting Permissions

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