ER MODEL AND BUSINESS RULES QUIZ

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

Disjoint with partial specialization

Disjoint with total specialization

Overlap with total specialization

Overlap with partial specialization

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

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

A rectangle represents which of the following in an EER?

Relationship

Optional One

Entity

Attribute

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Diamond

Circle

Oval

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?

Overlap with partial specialization

Overlap with total specialization

Disjoint with total specialization

Disjoint with partial specialization

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype discriminator is which of the following?

An attribute of the subtype whose values determine the subtype

An attribute of the subtype whose values determine the supertype

An attribute of the supertype whose values determine the subtype

An attribute of the supertype whose values determine the supertype

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Condition

Authorization

Integrity Control

Enabler

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

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

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

Attributes are assigned at the lowest logical level.

Attributes are assigned at the highest logical level.

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

TRUE ANSWER : ?
YOUR ANSWER : ?