ER Model and Business Rules
When an entity instance must be a member of only one subtype, it is which of the following?

Disjoint with total specialization
Overlap with total specialization
Overlap with partial specialization
Disjoint with partial specialization

ANSWER DOWNLOAD EXAMIANS APP

ER Model and Business Rules
Use of a supertype/subtype relationship is necessary when which of the following exists?

An instance of a subtype participates in a relationship that is the same as the other subtypes.
Attributes apply to all of the instances of an entity type.
An instance of a subtype participates in a relationship that is unique to that subtype.
No attributes apply to any of the instances of an entity type.

ANSWER DOWNLOAD EXAMIANS APP

ER Model and Business Rules
Inheritance is which of the following?

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
When a supertype entity inherits values of another supertype attribute

ANSWER DOWNLOAD EXAMIANS APP

ER Model and Business Rules
A supertype/subtype hierarchy has which of the following features?

Attributes are assigned at the lowest logical level.
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.

ANSWER DOWNLOAD EXAMIANS APP