Exam 3: The Enhanced E-R Model

A generic or template data model that can be reused as a starting point for a data modeling project is called a(n):

Mapping existing data to new data in a packaged data model is useful for developing migration plans.

In the figure below, which of the following apply to both OUTPATIENTs and RESIDENT_PATIENTs?

In the figure shown below, a rental unit can be both a house and an apartment.

A subtype can become a supertype if the subtype has other subtypes beneath it.

Which of the following is a generic entity type that has a relationship with one or more subtypes?

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype.

An attribute of the supertype that determines the target subtype(s) is called the:

In a supertype/subtype hierarchy, each subtype has:

The property by which subtype entities possess the values of all attributes of a supertype is called:

Adapting a packaged data model from your DBMS vendor makes it difficult for the application to work with other applications from the same vendor.

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.

Contrast the overlap rule to the disjoint rule.

The third step in the data modeling process with a packaged data model is:

Packaged data models can be developed using proven components.

How is the data modeling process different when starting with a purchased solution?

Which of the following is true of packaged data models?

An entity cluster can be formed by:

In packaged data models, all subtype/supertype relationships follow the ________ and ________ rules.

The following figure is an example of the overlap rule.