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

An action assertion is a statement that expresses some aspect of the static structure of the organization.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype discriminator is which of the following?

An attribute of the supertype whose values determine the supertype

An attribute of the supertype whose values determine the subtype

An attribute of the subtype whose values determine the subtype

An attribute of the subtype whose values determine the supertype

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.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype entity name should be which of the following?

Specific to the organization

All of these

A singular noun

Concise

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following statements concerning business rules is true?

It may include restrictions.

It should be complex.

It should not be convertible to computer code.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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 ERD that has had the entities clustered will display more entities.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑