ER MODEL AND BUSINESS RULES QUIZ

False

True

False

True

Attribute

Optional One

Relationship

Entity

An attribute of the subtype whose values determine the subtype

An attribute of the supertype whose values determine the supertype

An attribute of the supertype whose values determine the subtype

An attribute of the subtype whose values determine the supertype

Attributes are assigned at the highest logical level.

Attributes are assigned at the lowest logical level.

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

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

Disjoint with total specialization

Disjoint with partial specialization

Overlap with partial specialization

Overlap with total specialization

All of these

Corresponding object

Action

Anchor object

When a supertype entity inherits values of the subtype attribute

When a subtype entity inherits values of the supertype attribute

When a supertype entity inherits values of another supertype attribute

When a subtype entity inherits values of another subtype attribute

Concise

All of these

A singular noun

Specific to the organization

Defining one or more subtypes of the supertype and forming supertype/subtype relationships.

Defining one or more supertypes of the subtype and forming supertype/subtype relationships.

Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.

Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.