Section 5
(Answer all questions in this section)

  1. What uncommon relationship is described by the statements: "Each LINE must consist of many POINTS and each POINT must be a part of many LINES"

One to Many Optional

One to Many Mandatory

Many to Many Optional

  Many to Many Mandatory 



  2. When resolving an M:M relationship, the new relationships will always be __________ on the many side.

Optional

Recursive

  Mandatory 

Redundant



  3. Which of the following are relationship types? (Choose Two)

(Choose all correct answers)

One to Some

  Many to Many 

  One to Many 

One to Another



  4. Many to many relationships between entities usually hide what?

Another relationship

  Another entity 

More attributes

Uniqueness



  5. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? (Choose Two)

(Choose all correct answers)

  STUDENT and CLASS 

TREE and SEEDLING

PHONE NUMBER and SIM CARD

  CAR and DRIVER 



  6. If the same relationship is represented twice in an Entity Relationship Model, it is said to be:

Replicated

Removable

  Redundant 

Resourceful



  7. When are relationships unnecessary?

  When you can derive the relationship from other relationships in the model 

When they have the same visual structure but different meaning

When the information does not relate to the model

When the relationships connect 2 entities and they each have distinct meanings