Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    4

    ER Diagram, any suggestion will be appreciate.

    Hi dudes,

    I am a newbie to the database, I have drawn a E-R diagram, but I ain't sure if it makes any sense to you guys.
    Attached Thumbnails Attached Thumbnails E-R 1.bmp  

  2. #2
    Join Date
    Dec 2004
    Posts
    54

    Time to "Reorder"

    Hi,
    Yes, you certainly need some help here. I apologize for not giving you a conceptual model myself, I'm tired.

    Customer, Orders and Items.
    Customers know about, request, or purchase, etc. 'Items' through an order. So customers don't generally have a direct relationship to the 'Items'.

    An item can be on zero, one or many orders.
    An order can be for one or many items.
    SO ... you see there's a many to many between order and items.

    Here's a model link for you. Replace the 'Aircraft Parts' entity with your 'Items' entity.

    It appears you don't need the Customer Quotation and Quotation Items entity.

    http://www.databaseanswers.org/data_...arts/index.htm

    Enjoy!!
    Vmusic

  3. #3
    Join Date
    Feb 2005
    Posts
    4
    Thanks a lot mate!!

  4. #4
    Join Date
    Aug 2009
    Posts
    1
    Marked! I will come back to check this soon!thanks a lot.:-)
    demande credit
    immobilier simulation pret de france taux calcul
    courtier
    Une simulation credit immobilier de France
    a faire un
    pret.
    demande
    credit immobilier simulation pret de france taux calcul
    courtier

Posting Permissions

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