Test: Quiz: Relationship Types

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