Exam 3: The Enhanced E-R Model and Business Rules

In a supertype/subtype hierarchy,subtypes that are lower in the hierarchy inherit attributes from not only their immediate supertype but from all ________ in the hierarchy.

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

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

Entity clustering is a methodology for grouping one or more entity types and associated relationships into a single abstract entity type.

The subtype discriminator in the figure below is:

Attribute inheritance is a property of subtype entities where they inherit ________ of all attributes of the supertype.

Packaged data models can be developed using proven components.

A packaged data model can either be ________ or ________.

The ________ specifies that an entity instance can simultaneously be a member of two or more subtypes.

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

The figure below,is an example of a(n):

A subtype is a generic entity that has a relationship with one or more entities at a lower level.

Why are packaged data models gaining popularity?

Compare and contrast generalization and specialization.

A member of a subtype does NOT necessarily have to be a member of the supertype.

In the figure below,a student:

Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors.

A ________ is a constraint that addresses the question of whether an instance of a supertype may simultaneously be a member of two or more subtypes.

Packaged data models:

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