Section 5 Quiz
(Answer all questions in this section)
1.If two entities have two relationships between them, these relationships
Mark for Review
can be either _____________ or _____________ .
(1) Points
Resourced and Really Good
Replicated or Required
Redundant and Replicated
Redundant or Required (*)
Incorrect. Refer to Section 5 Lesson 2.
2.What relationship is described by the statements: "Each CUSTOMER may
Mark for Review
place one or more ORDERs, each ORDER must be placed by one and only
(1) Points
one CUSTOMER"
Many to More
One to Many (*)
One to One
Many to Many
Correct
3.Which of the following pairs of entities is most likely to be modeled as a
Mark for Review
M:M relationship?
(1) Points
TREE and BRANCH
TEACHER and SUBJECT AREA (*)
PERSON and FINGERPRINT
CAR and WHEEL
Incorrect. Refer to Section 5 Lesson 2.
4.What uncommon relationship is described by the statements: "Each DNA
Mark for Review
SAMPLE may be taken from one and only one PERSON and each PERSON
(1) Points
may provide one and only one DNA SAMPLE"
Many to Many Mandatory
One to One Optional (*)
One to Many Mandatory
One to Many Optional
Correct
5.If the same relationship is represented twice in an Entity Relationship
Mark for Review
Model, it is said to be:
(1) Points
Removable
Resourceful
Replicated
Redundant (*)
Correct
Section 5 Quiz
(Answer all questions in this section)
6. What do you call the entity created when you resolve a M:M
Mark for Review
relationship?
(1) Points
Inclusion entity
M:M entity
Recursive entity
Intersection entity (*)
Correct
7. If an intersection entity is formed that contains no attributes of its own,
Mark for Review
its uniqueness may be modeled by
(1) Points
Creating new attributes.
Barring the relationships to the original entities. (*)
Placing the UID attributes from the original entities into the
intersection entity.
None of the above.
Correct
8. Many to many relationships between entities usually hide what?
Mark for Review
(1) Points
Another entity (*)
Uniqueness
Another relationship
More attributes
Correct
9. Intersection Entities often have the relationships participating in the UID,
Mark for Review
so the relationships are often barred. True or False?
(1) Points
True (*)
False
Correct
10.A relationship on an ERD can have attributes. True or False?
Mark for Review
(1) Points
True
False (*)
Incorrect. Refer to Section 5 Lesson 3.
Section 5 Quiz
(Answer all questions in this section)
11.A Diamond on a relationship indicates the Relationship as Non-
Mark for Review
Tranferable. True or False?
(1) Points
True (*)
False
Correct
12.The relationship between CUSTOMER and RECEIPT is an example of a
Mark for Review
non-transferable relationship. True or False?
(1) Points
True (*)
False
Correct
13.If a relationship can be moved between instances of the entities it
Mark for Review
connects, it is said to be:
(1) Points
Transferable (*)
Committed
Implicit
Recursive
Correct
14.A non-transferable relationship means the relationship is manatory at
Mark for Review
both sides. True or False?
(1) Points
True
False (*)
Incorrect. Refer to Section 5 Lesson 1.
15.Which of the following is an example of a non-transferable relationship
Mark for Review
(1) Points
STUDENT to COURSE
EMPLOYEE to DEPARTMENT
PERSON to BIRTH PLACE (*)
TEACHER to SCHOOL
Correct
