ER MODEL AND BUSINESS RULES QUIZ

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Inheritance is which of the following?

When a supertype entity inherits values of another supertype attribute

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

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 : ?

An oval represents which of the following in an EER?

Entity

Relationship

Attribute

Optional One

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A rectangle represents which of the following in an EER?

Relationship

Entity

Attribute

Optional One

TRUE ANSWER : ?
YOUR ANSWER : ?

If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A supertype can only have only one subtype.

False

True

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 action assertion is a statement that expresses some aspect of the static structure of the organization.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑