ER MODEL AND BUSINESS RULES QUIZ

Which of the following is not one of the three ways to classify an action assertion?

Authorization

Enabler

Integrity Control

Condition

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Use of a supertype/subtype relationship is necessary when which of the following exists?

Attributes apply to all of the instances of an entity type.

No attributes apply to any of the instances of an entity type.

An instance of a subtype participates in a relationship that is the same as the other subtypes.

An instance of a subtype participates in a relationship that is unique to that subtype.

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype entity name should be which of the following?

Specific to the organization

Concise

All of these

A singular noun

TRUE ANSWER : ?
YOUR ANSWER : ?

Inheritance is which of the following?

When a supertype entity inherits values of the subtype attribute

When a subtype entity inherits values of another subtype attribute

When a subtype entity inherits values of the supertype attribute

When a supertype entity inherits values of another supertype attribute

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

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

Overlap with partial specialization

Disjoint with total specialization

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

There is cardinality on an EER between the supertype and subtype.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Action assertions have traditionally been implemented within an application program.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?