ER MODEL AND BUSINESS RULES QUIZ

False

True

Corresponding object

All of these

Anchor object

Action

Attributes are assigned at the highest 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 lowest logical level.

False

True

An attribute of the subtype whose values determine the subtype

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

Each supertype has only one attribute.

Each supertype has only one subtype.

Each subtype has only one attribute.

Each subtype has only one supertype.

A singular noun

Specific to the organization

Concise

All of these

False

True

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

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

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

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

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

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