ER MODEL AND BUSINESS RULES QUIZ

Each supertype has only one attribute.

Each supertype has only one subtype.

Each subtype has only one supertype.

Each subtype has only one attribute.

False

True

True

False

Overlap with partial specialization

Disjoint with partial specialization

Overlap with total specialization

Disjoint with total specialization

Action

Corresponding object

All of these

Anchor object

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.

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.

Attribute

Relationship

Entity

Optional One

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.

False

True

Oval

Diamond

Rectangle

Circle