ER MODEL AND BUSINESS RULES QUIZ

Each subtype has only one attribute.

Each supertype has only one attribute.

Each subtype has only one supertype.

Each supertype has only one subtype.

Integrity Control

Condition

Authorization

Enabler

False

True

All of these

Specific to the organization

A singular noun

Concise

It should not be convertible to computer code.

It should be complex.

It may include restrictions.

All of these

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.

When a subtype entity inherits values of another subtype attribute

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

False

True

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

Attributes are assigned at the highest logical level.

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

Attributes are assigned at the lowest logical level.

False

True