ER MODEL AND BUSINESS RULES QUIZ

When an entity instance must be a member of only one subtype, it is which of the following?

Overlap with total specialization

Overlap with partial specialization

Disjoint with partial specialization

Disjoint with total specialization

TRUE ANSWER : ?
YOUR ANSWER : ?

Inheritance is which of the following?

When a subtype entity inherits values of the supertype attribute

When a supertype entity inherits values of the subtype attribute

When a subtype entity inherits values of another subtype attribute

When a supertype entity inherits values of another supertype attribute

TRUE ANSWER : ?
YOUR ANSWER : ?

An oval represents which of the following in an EER?

Attribute

Entity

Relationship

Optional One

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Authorization

Integrity Control

Condition

Enabler

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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

A subtype entity name should be which of the following?

All of these

A singular noun

Specific to the organization

Concise

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Diamond

Oval

Rectangle

Circle

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

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

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

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

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

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

TRUE ANSWER : ?
YOUR ANSWER : ?