ER MODEL AND BUSINESS RULES QUIZ

Entity

Relationship

Optional One

Attribute

It should not be convertible to computer code.

All of these

It should be complex.

It may include restrictions.

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

Attributes are assigned at the lowest logical level.

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

Attributes are assigned at the highest logical level.

Relationship

Entity

Optional One

Attribute

False

True

Concise

A singular noun

All of these

Specific to the organization

False

True

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

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

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.

Overlap with partial specialization

Overlap with total specialization

Disjoint with partial specialization

Disjoint with total specialization

False

True