ER MODEL AND BUSINESS RULES QUIZ

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

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 total specialization

Disjoint with total specialization

Overlap with partial specialization

Disjoint with partial specialization

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

An action assertion must include which of the following?

All of these

Action

Anchor object

Corresponding object

TRUE ANSWER : ?
YOUR ANSWER : ?

A rectangle represents which of the following in an EER?

Attribute

Relationship

Entity

Optional One

TRUE ANSWER : ?
YOUR ANSWER : ?

Action assertions have traditionally been implemented within an application program.

False

True

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.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following symbols is not used in an ERD?

Circle

Diamond

Oval

Rectangle

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

Disjoint with partial specialization

Overlap with partial specialization

Disjoint with total specialization

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 subtype whose values determine the supertype

An attribute of the supertype whose values determine the supertype

An attribute of the supertype whose values determine the subtype

TRUE ANSWER : ?
YOUR ANSWER : ?