ER MODEL AND BUSINESS RULES QUIZ

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

Attributes are assigned at the lowest logical level.

Attributes are assigned at the highest logical level.

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

Rectangle

Circle

Oval

Diamond

False

True

It may include restrictions.

It should not be convertible to computer code.

It should be complex.

All of these

Authorization

Enabler

Condition

Integrity Control

When a subtype entity inherits values of the supertype attribute

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

Disjoint with total specialization

Overlap with total specialization

Disjoint with partial specialization

Overlap with partial specialization

Relationship

Optional One

Entity

Attribute

True

False

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.

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