ER MODEL AND BUSINESS RULES QUIZ

A supertype/subtype hierarchy has which of the following features?

Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.

Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.

Attributes are assigned at the highest logical level.

Attributes are assigned at the lowest logical level.

TRUE ANSWER : ?
YOUR ANSWER : ?

A supertype can only have only one subtype.

True

False

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

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 unique to that subtype.

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

TRUE ANSWER : ?
YOUR ANSWER : ?

An entity cluster is a set of one or more entity types and associated relationships.

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 supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Condition

Integrity Control

Enabler

Authorization

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Diamond

Oval

Circle

Rectangle

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?

Disjoint with total specialization

Disjoint with partial specialization

Overlap with partial specialization

Overlap with total specialization

TRUE ANSWER : ?
YOUR ANSWER : ?

↑