FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: The Enhanced E-R Model

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

The following figure is an example of:

A) partial specialization.
B) disjoint completeness.
C) total specialization.
D) transunion constraint.

E) All of the above
F) A) and D)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

A good method for identifying inconsistencies and finding hidden meaning in the customized purchased data model is:

A) data analysis.
B) data volume usage analysis.
C) user interviews.
D) data profiling.

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload

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.

All of the following are advantages of packaged data models EXCEPT:

An entity cluster can be formed by:

There are three separate discriminators in the following diagram because of the overlap rule.

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

It is easier to share information across organizations if companies in the same industry use the same universal data model as the basis for their organizational databases.

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

The following diagram is an example of a supertype/subtype hierarchy.

When identifying the parts of the packaged data model that apply to your organization, one should first start with:

A universal data model is a generic or template data model that can be reused as a starting point for a data modeling project.

An entity cluster can have a relationship with another entity cluster much the same way that an entity can have a relationship with another entity.

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

A completeness constraint may specify that each entity of the supertype must be a member of some subtype in the relationship.

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

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

When the total specialization rule is set for a supertype/subtype relationship, one could roughly compare the supertype to an abstract class in object-oriented programming.

Creating a data model from a packaged data model requires much more skill than creating one from scratch.