Answer to Exercise ER-7
  1. The minimum number of Cs that can be associated with one A is 1. I know this because the existence of the C to A relationship is mandatory. The maximum number of Cs that can be associated with one A is unlimited (or many). I know this because the cardinality of the C to A relationship is 1-M.
  2. Answers
    1. This is consistent with the diagram since Mackenzie is managing one project. A person must manage at least one project.
    2. This is consistent with the diagram since Lindsey is managing two projects. A person must manage at least one project with no upper limit.
    3. This is inconsistent with the diagram. The diagram states that a person must manage at least one project and Joe does not manage any.

Return to ER exercises.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License