Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2013
    Posts
    1

    Question Am I interpreting Database Cardinality and Optionality relationships correctly?

    I have been working on a Database Modeling assignment over the past few days. I am at the point where I have to draw a UML Diagram which shows cardinality and optionality. I am stuck on this concept, want to make sure I am doing it correct, interpreting the diagram correctly, and that my diagram is understandable.

    I would appreciate it if you someone review my diagram and my answers to see if I am doing this correct and understanding the concept. You can view it at this link. Please view it and write down the what you think the relationship between the tables are based upon the diagram so I can compare it to my answers below.

    https://docs.google.com/file/d/0B6hk...it?usp=sharing

    or by copying and pasting this in your url bar: https://docs.google.com/file/d/0B6hk...it?usp=sharing

    Please review it first to see if you understand the relationship rules. I made the diagram this afternoon and did not have time to edit it. So, in the diagram, PersonID should be HistoryID for all tables except PatientHistory and Persons.

    You can find my explanations about the relationships between the table at this location.

    https://docs.google.com/file/d/0B6hk...it?usp=sharing or
    at this link
    https://docs.google.com/file/d/0B6hk...it?usp=sharing

    thank you
    Attached Files Attached Files

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
  •