ER MODEL AND BUSINESS RULES QUIZ

Defining one or more subtypes of the supertype and not 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 forming supertype/subtype relationships.

Optional One

Entity

Relationship

Attribute

A singular noun

Specific to the organization

Concise

All of these

True

False

False

True

True

False

Attributes are assigned at the lowest logical level.

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

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

Attributes are assigned at the highest logical level.

Disjoint with total specialization

Overlap with total specialization

Overlap with partial specialization

Disjoint with partial specialization

Condition

Integrity Control

Authorization

Enabler

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

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

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

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