ER MODEL AND BUSINESS RULES QUIZ

True

False

All of these

It may include restrictions.

It should be complex.

It should not be convertible to computer code.

Relationship

Entity

Optional One

Attribute

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

Attributes are assigned at the highest logical level.

Attributes are assigned at the lowest logical level.

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

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 supertypes of the subtype and forming supertype/subtype relationships.

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

An attribute of the supertype whose values determine the subtype

An attribute of the subtype 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

Each supertype has only one subtype.

Each subtype has only one attribute.

Each subtype has only one supertype.

Each supertype has only one attribute.

False

True

A singular noun

Concise

Specific to the organization

All of these

Overlap with partial specialization

Overlap with total specialization

Disjoint with partial specialization

Disjoint with total specialization