Section 5: Relationship Fundamentals Quiz

When you resolve a M:M by creating an intersection entity, this new entity will always inherit:

A relationship to each entity from the original M:M.

A non-transferable relationship is represented by which of the following symbols?

Diamonds

A non-transferable relationship means the relationship is manatory at both sides. True or False?

False

A relationship on an ERD can have attributes. True or False?

False

Every ERD must have at least one non-transferable relationship. True or False?

False

Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False?

False

One to many relationships are the most uncommon type of relationships in an ERD. True or False?

False

What do you call the entity created when you resolve a M:M relationship?

Intersection entity

If a relationship can NOT be moved between instances of the entities it connects, it is said to be:

Non-Transferable

What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER"

One to Many

Which of the following is an example of a non-transferable relationship

PERSON to BIRTH PLACE

If the same relationship is represented twice in an Entity Relationship Model, it is said to be:

Redundant

If two entities have two relationships between them, these relationships can be either _____________ or _____________ .

Redundant or Required

A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship. True or False?

True

Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False?

True