Section 7: Arcs, hierarchies, and Recursive Modeling Quiz

Which of the following would best be represented by an arc?

DELIVERY ADDRESS (Home, Office)

Arcs are used to visually represent _________ between two or more relationships in an ERD.

Exclusivity

A recursive relationship must be Mandatory at both ends. True or False?

False

A single relationship can be both Recursive and Hierarchical at the same time. True or False?

False

All relationships participating in an arc must be mandatory. True or False?

False

Cascading UIDs are a feature often found in what type of Relationship?

Heirarchical Relationship

A Recursive Relationship is represented on an ERD by a/an:

Pig's Ear

A relationship between an entity and itself is called a/an:

Recursive Relationship

A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?

True

An arc can often be modeled as Supertype and Subtypes. True or False?

True

Arcs model an Exclusive OR constraint. True or False?

True

Business organizational charts are often modeled as a Hierarchical relationship. True or False?

True

Which of the following can be added to a relationship?

An arc can be assigned

To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.

Arc

Every business has restrictions on which attribute values and which relationships are allowed. These are known as:

Constraints.