Question 1

An entity instance of a subtype represents the same entity instance of the supertype.

Accepted Answer

A) True 
 B)False

Question 2

The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.

Accepted Answer

A)  semi-specialization 
B)  total specialization 
C)  partial specialization 
D)  disjointness 
A)  semi-specialization 
B)  total specialization 
C)  partial specialization 
D)  disjointness

Question 3

The ________ rule specifies that an entity can be a member of only one subtype at a time.

Accepted Answer

A)  exclusion 
B)  disjoint 
C)  removal 
D)  inclusion 
A)  exclusion 
B)  disjoint 
C)  removal 
D)  inclusion

Question 4

Explain why the E-R model needed to be expanded into the enhanced E-R model.

Accepted Answer

The business environment has drastically

Question 5

Compare and contrast generalization and specialization.

Accepted Answer

Generalization is the process of definin

Question 6

Because a purchased data model is extensive, you begin by identifying the parts of the data model that apply to your data modeling situation.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  entities. 
B)  attributes. 
C)  primary keys. 
D)  relationships. 
A)  entities. 
B)  attributes. 
C)  primary keys. 
D)  relationships.

Question 10

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

Accepted Answer

A)  packaged data models can be built using proven components evolved from cumulative experiences. 
B)  projects take less time and cost less. 
C)  the data model is easier to evolve. 
D)  more one-to-one relationships give the data model more flexibility. 
A)  packaged data models can be built using proven components evolved from cumulative experiences. 
B)  projects take less time and cost less. 
C)  the data model is easier to evolve. 
D)  more one-to-one relationships give the data model more flexibility.

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A)  Define one vehicle entity type to hold all entities. 
B)  Define a separate entity type for each entity. 
C)  Define a supertype called vehicle and make each of the entities subtypes. 
D)  Keep only the Truck entity type. 
A)  Define one vehicle entity type to hold all entities. 
B)  Define a separate entity type for each entity. 
C)  Define a supertype called vehicle and make each of the entities subtypes. 
D)  Keep only the Truck entity type.

Question 15

The following diagram shows:

Accepted Answer

A)  total specialization. 
B)  partial specialization. 
C)  the overlap rule. 
D)  subtype discriminator. 
A)  total specialization. 
B)  partial specialization. 
C)  the overlap rule. 
D)  subtype discriminator.

Question 16

Packaged data models:

Accepted Answer

A)  are ready to use right out of the box. 
B)  require customization. 
C)  allow partial specialization. 
D)  cannot be used for most applications. 
A)  are ready to use right out of the box. 
B)  require customization. 
C)  allow partial specialization. 
D)  cannot be used for most applications.

Question 17

In the figure below, which of the following is a subtype of patient?

Accepted Answer

A)  Outpatient 
B)  Physician 
C)  Bed 
D)  Date_Hired 
A)  Outpatient 
B)  Physician 
C)  Bed 
D)  Date_Hired

Question 18

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

Accepted Answer

A)  supertype/subtype hierarchy. 
B)  hierarchical data model. 
C)  entity cluster. 
D)  column cluster. 
A)  supertype/subtype hierarchy. 
B)  hierarchical data model. 
C)  entity cluster. 
D)  column cluster.

Question 19

In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy.

Accepted Answer

A) True 
 B)False

Question 20

Discuss how attributes are assigned in a supertype/subtype hierarchy.

Accepted Answer

Attributes are assigned at the highest l

An entity instance of a subtype represents the same entity instance of the supertype.

The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.

The ________ rule specifies that an entity can be a member of only one subtype at a time.

Explain why the E-R model needed to be expanded into the enhanced E-R model.

Compare and contrast generalization and specialization.

Because a purchased data model is extensive, you begin by identifying the parts of the data model that apply to your data modeling situation.

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

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:

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

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

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

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

The following diagram shows:

Packaged data models:

In the figure below, which of the following is a subtype of patient?

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

In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy.

Discuss how attributes are assigned in a supertype/subtype hierarchy.

The Database Environment and Development Process

Modeling Data in the Organization

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 3: The Enhanced E-R Model

An entity instance of a subtype represents the same entity instance of the supertype.

The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.

The ________ rule specifies that an entity can be a member of only one subtype at a time.

Explain why the E-R model needed to be expanded into the enhanced E-R model.

Compare and contrast generalization and specialization.

Because a purchased data model is extensive, you begin by identifying the parts of the data model that apply to your data modeling situation.

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

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:

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

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

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

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

The following diagram shows:

Packaged data models:

In the figure below, which of the following is a subtype of patient?

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

In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy.

Discuss how attributes are assigned in a supertype/subtype hierarchy.

The Database Environment and Development Process

Modeling Data in the Organization

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters