ER MODEL AND BUSINESS RULES QUIZ

Circle

Diamond

Oval

Rectangle

Attribute

Entity

Optional One

Relationship

When a supertype entity inherits values of the subtype attribute

When a subtype entity inherits values of another subtype attribute

When a supertype entity inherits values of another supertype attribute

When a subtype entity inherits values of the supertype attribute

Attributes are assigned at the highest logical level.

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

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

Attributes are assigned at the lowest logical level.

False

True

An attribute of the subtype whose values determine the supertype

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 subtype

Overlap with partial specialization

Disjoint with partial specialization

Overlap with total specialization

Disjoint with total specialization

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.

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.

False

True

All of these

A singular noun

Concise

Specific to the organization