Help with Entity Relationship Diagrams in MS Access

Discussion in 'Windows, Linux & Others on the Mac' started by sammich, May 24, 2008.

  1. sammich macrumors 601

    sammich

    Joined:
    Sep 26, 2006
    Location:
    Sarcasmville.
    #1
    I've got a small ERD related database assignment to complete in a few days. I've think I've created the tables correctly, I've followed all the rules right, but the relationships that Access makes for me when I drag the links come out in reverse.

    I've attached files below (yes they are zipped and they shouldn't have any viruses in them :D). I've included both 2007 and 2003 copies in the zip file.

    The other two attachments: the PDF is the ERD we need to follow, and the image is what I've managed to create.

    And you can see that it's obviously wrong even without looking at the correct ERD.

    Can anyone shed some light on this problem for me?

    Thanks,
    Sam
     

    Attached Files:

  2. Eraserhead macrumors G4

    Eraserhead

    Joined:
    Nov 3, 2005
    Location:
    UK
    #2
    You need to put the remote key (i.e. the one referencing the primary key) in the "to many" object in Access. This is because each object has a unique primary key, but many remote objects can reference a single primary key.

    PS Is that entity-relationship diagram given for the assignment, it looks really poor :eek:.
     
  3. sammich thread starter macrumors 601

    sammich

    Joined:
    Sep 26, 2006
    Location:
    Sarcasmville.
    #3
    Thanks for replying Eraserhead, but how do I change the 'remote key' to the 'to many' object? I know what you're trying to say but I don't know how to change it in Access.

    Totally agree with you about that ERD diagram though. Uni lecturers, lazy as usual.
     
  4. Eraserhead macrumors G4

    Eraserhead

    Joined:
    Nov 3, 2005
    Location:
    UK
    #4
    I can't work out how to get Access to display the Infinities/Ones, but the following is how it should be:

    Capture-RShip.PNG

    The person can own as many books as they want, but each book can only have one owner.
     

Share This Page