Skip to content

Reading EER Diagrams

Consider the EER model below and answer the questions, explaining how you got the answers from the diagram notation.

EER model with X, Y, Z, F, R, W

  1. What are all the attributes of a Y?
  2. What is the unique identifier of a W?
  3. True or False: Whatever jumps over an F is either a Y or a Z.
  4. Identify the multi-valued attribute in the diagram and explain what it tells us.
  5. True or False: An R may be visited by something that does not jump over an F.
  6. What are the minimum and maximum number of Y’s an R may be visited by?