ER MODEL AND BUSINESS RULES QUIZ

A subtype entity name should be which of the following?

A singular noun

Specific to the organization

Concise

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?

Overlap with partial specialization

Disjoint with total specialization

Overlap with total specialization

Disjoint with partial specialization

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An oval represents which of the following in an EER?

Relationship

Optional One

Entity

Attribute

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype discriminator is which of the following?

An attribute of the subtype whose values determine the subtype

An attribute of the supertype whose values determine the subtype

An attribute of the supertype whose values determine the supertype

An attribute of the subtype whose values determine the supertype

TRUE ANSWER : ?
YOUR ANSWER : ?

An entity cluster is a set of one or more entity types and associated relationships.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑