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

    Entity-Relationship Model, Help

    So I got a task i need to do and it includes doing a entity-relationship model in visio. I have to show all entities and relationships as well as each entity should include a description of the entity, its attributes, and its primary key.Oh and each relationship needs to show its cardinality.

    So far I have done what is attached.

    I'm not asking anyone to do it for me. I am just wanting to know what I have done wrong and what I havent done at all, as stated above, If anyone could lend me a hand and let me know, it would be greatly appreciated

    Thanks
    Attached Thumbnails Attached Thumbnails Untitled.jpg  

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    looks okay, except for Contributors, which is all messed up, the FKs are in the wrong table
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2010
    Posts
    4
    Quote Originally Posted by r937 View Post
    looks okay, except for Contributors, which is all messed up, the FKs are in the wrong table
    Thanks for the feedback, what does it mean when it says "relationship needs to show its cardinality"

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by I_like_help View Post
    what does it mean when it says "relationship needs to show its cardinality"
    1-to-1 or 1-to-many
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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