ER MODEL AND BUSINESS RULES QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A supertype can only have only one subtype.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A supertype/subtype hierarchy is which of the following?

Each subtype has only one attribute.

Each supertype has only one subtype.

Each subtype has only one supertype.

Each supertype has only one attribute.

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Authorization

Enabler

Condition

Integrity Control

TRUE ANSWER : ?
YOUR ANSWER : ?

Action assertions have traditionally been implemented within an application program.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype discriminator is which of the following?

An attribute of the supertype whose values determine the subtype

An attribute of the subtype whose values determine the supertype

An attribute of the supertype whose values determine the supertype

An attribute of the subtype whose values determine the subtype

TRUE ANSWER : ?
YOUR ANSWER : ?

It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

There is cardinality on an EER between the supertype and subtype.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑