ER MODEL AND BUSINESS RULES QUIZ

True

False

Each subtype has only one attribute.

Each supertype has only one attribute.

Each supertype has only one subtype.

Each subtype has only one supertype.

When a subtype entity inherits values of another subtype attribute

When a supertype entity inherits values of another supertype attribute

When a subtype entity inherits values of the supertype attribute

When a supertype entity inherits values of the subtype attribute

Defining one or more subtypes of the supertype 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.

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

Disjoint with total specialization

Overlap with total specialization

Disjoint with partial specialization

Overlap with partial specialization

False

True

True

False

False

True

An attribute of the supertype whose values determine the subtype

An attribute of the supertype whose values determine the supertype

An attribute of the subtype whose values determine the supertype

An attribute of the subtype whose values determine the subtype

True

False