ER MODEL AND BUSINESS RULES QUIZ

A supertype/subtype hierarchy has which of the following features?

Attributes are assigned at the highest logical level.

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.

TRUE ANSWER : ?
YOUR ANSWER : ?

Total specialization is represented by double lines between the supertype and subtype on an EER.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A supertype can only have only one subtype.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Generalization is the process of defining more general entity types from a set of more specialized entity types.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An oval represents which of the following in an EER?

Optional One

Attribute

Entity

Relationship

TRUE ANSWER : ?
YOUR ANSWER : ?

A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An entity instance of a subtype represents the same entity instance of a supertype.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

When an entity instance must be a member of only one subtype, it is which of the following?

Overlap with total specialization

Overlap with partial specialization

Disjoint with partial specialization

Disjoint with total specialization

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not one of the three ways to classify an action assertion?

Integrity Control

Enabler

Authorization

Condition

TRUE ANSWER : ?
YOUR ANSWER : ?

Packaged data models are meant to be exactly right straight out of the box.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑