a) True
b) False
2) In a business that sells pet food choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse or cat). (Choose Two)
a) Each FOOD TYPE must be suitable for one or more ANIMALs.
b) Each ANIMAL must be the seller of one or more FOOD
TYPES.
c) Each FOOD TYPE may be made from one or more ANIMALs.
d) Each FOOD TYPE may be given to one or more ANIMALs.
3) One Relationship can be both mandatory and optional at different ends.
a) True
b) False
4) Matrix Diagrams are used to verify an ERD.
a) True
b) False
5) Entity names are always singular.
a) True
b) False
6) Arcs are used to visually represent _________ between two or more relationships in an ERD.
a) Sameness
b) Differences
c) Exclusivity
d) Inheritance
7) Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc.
a) True
b) False
8) Which of the following is NOT a relationship type?
a) Some to None
b) One to One
c) One to Many
d) Many to Many
9) If Audit trail attributes are added to an entity they must be in the entities they are auditing.
a) True
b) False
10) Modeling historical data can produce a unique identifier that always excludes dates.
a) True
b) False
11) A recursive relationship must Mandatory at both ends.
a) True
b) False
12) An arc can also be modeled as Supertype and Subtypes.
a) True
b) False
---
Suggested Answers
1) b
2) a, d
3) a
4) a
5) a
6) c
7) b
8) a
9) a
10) b
11) b
12) a
