ER MODEL AND BUSINESS RULES QUIZ

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 subtype entity inherits values of another subtype attribute

When a supertype entity inherits values of the subtype attribute

TRUE ANSWER : ?
YOUR ANSWER : ?

An entity instance of a subtype represents the same entity instance of a supertype.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An action assertion must include which of the following?

Corresponding object

Action

All of these

Anchor object

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

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

Which of the following statements concerning business rules is true?

All of these

It should be complex.

It should not be convertible to computer code.

It may include restrictions.

TRUE ANSWER : ?
YOUR ANSWER : ?

Specialization is which of the following processes?

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

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

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

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

TRUE ANSWER : ?
YOUR ANSWER : ?

↑