ER MODEL AND BUSINESS RULES QUIZ

Attributes apply to all of the instances of an entity type.

An instance of a subtype participates in a relationship that is the same as the other subtypes.

No attributes apply to any of the instances of an entity type.

An instance of a subtype participates in a relationship that is unique to that subtype.

True

False

False

True

Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.

Attributes are assigned at the lowest logical level.

Attributes are assigned at the highest logical level.

Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.

Each subtype has only one attribute.

Each subtype has only one supertype.

Each supertype has only one subtype.

Each supertype has only one attribute.

All of these

Action

Corresponding object

Anchor object

True

False

Disjoint with total specialization

Overlap with total specialization

Disjoint with partial specialization

Overlap with partial specialization

Disjoint with total specialization

Overlap with total specialization

Overlap with partial specialization

Disjoint with partial specialization

An attribute of the subtype whose values determine the subtype

An attribute of the supertype whose values determine the subtype

An attribute of the subtype whose values determine the supertype

An attribute of the supertype whose values determine the supertype