Exam 3: The Enhanced E-R Model

Subtypes should be used when:

An entity cluster should focus on some area of interest to some community of users, developers, or managers.

The subtype discriminator in the figure below is:

The following figure is an example of:

In the figure below, a student:

It is easy to miss the opportunity to visualize future requirements shown in the full data model when using a packaged data model.

In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ________ rule.

The process of defining one or more subtypes of a supertype and forming relationships is called:

The most important challenge of customizing a purchased data model is determining the business rules that will be established through the data model.

In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized?

Which statement is true about the following diagram?

Packaged data models are as flexible as possible, because all supertype/subtype relationships allow the total specialization and overlap rules.

When subtypes are overlapping, an additional field must be added to the supertype to act as a discriminator.

Generalization is a top-down process.

Using a packaged data model, projects take less time and cost because:

Discuss when one would use total specialization and when one would use partial specialization.

A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype.

The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

The most important challenge of customizing a purchased data model is:

Regardless of the business situation, a member of the supertype is always a member of more than one subtype.