ER MODEL AND BUSINESS RULES QUIZ

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

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 one of the following symbols is not used in an ERD?

Rectangle

Oval

Diamond

Circle

TRUE ANSWER : ?
YOUR ANSWER : ?

Action assertions have traditionally been implemented within an application program.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An oval represents which of the following in an EER?

Attribute

Entity

Optional One

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

A supertype/subtype hierarchy is which of the following?

Each subtype has only one supertype.

Each supertype has only one attribute.

Each supertype has only one subtype.

Each subtype has only one attribute.

TRUE ANSWER : ?
YOUR ANSWER : ?

A rectangle represents which of the following in an EER?

Relationship

Attribute

Optional One

Entity

TRUE ANSWER : ?
YOUR ANSWER : ?

Specialization is which of the following processes?

Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.

Defining one or more supertypes of the subtype and forming supertype/subtype relationships.

Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.

Defining one or more subtypes of the supertype and forming supertype/subtype relationships.

TRUE ANSWER : ?
YOUR ANSWER : ?

An ERD that has had the entities clustered will display more entities.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?