Section 1
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" Mark for Review
(1) Points
One to Many Optional
One to Many Mandatory
Many to Many Optional
Many to Many Mandatory (*)
2. If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
Replicated
Removable
Redundant (*)
Resourceful
3. When are relationships unnecessary? Mark for Review
(1) Points
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
4. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
STUDENT and CLASS (*)
TREE and SEEDLING
PHONE NUMBER and SIM CARD
CAR and DRIVER (*)
5. When resolving an M:M relationship, the new relationships will always be __________ on the many side. Mark for Review
(1) Points
optional
recursive
mandatory (*)
redundant
6. Which of the following are relationship types? (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
One to Some
Many to Many (*)
One to Many (*)
One to Another
7. Many to many relationships between entities usually hide what? Mark for Review
(1) Points
Another relationship
Another entity (*)
More attributes
Uniqueness
