Question 1

The following figure is an example of total specialization.

Accepted Answer

A) True 
 B)False  False

Question 2

One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same.

Accepted Answer

A) True 
 B)False  True

Question 3

Packaged data models cause projects to take more time to build.

Accepted Answer

A) True 
 B)False  False

Question 4

The following figure shows an example of:

Accepted Answer

A)  the disjoint rule. 
B)  the completeness rule. 
C)  the underdog rule. 
D)  the overlap rule. 
A)  the disjoint rule. 
B)  the completeness rule. 
C)  the underdog rule. 
D)  the overlap rule.

Question 5

Which of the following is a completeness constraint?

Accepted Answer

A)  Total specialization 
B)  Partial generalization 
C)  Total recall 
D)  Partial hybridization 
A)  Total specialization 
B)  Partial generalization 
C)  Total recall 
D)  Partial hybridization

Question 6

In the figure shown below, a rental unit can be both an apartment and a house but must be at least one.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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.

Accepted Answer

A)  subtypes 
B)  supertypes 
C)  constraints 
D)  dimensions 
A)  subtypes 
B)  supertypes 
C)  constraints 
D)  dimensions

Question 9

Explain the terms subtype and supertype. Discuss the differences between them.

Accepted Answer

A subtype is an entity which represents

Question 10

In the figure shown below, a rental unit has to be either a house or an apartment.

Accepted Answer

A) True 
 B)False

Question 11

The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes.

Accepted Answer

A)  disjoint 
B)  overlap 
C)  partial specialization 
D)  total specialization 
A)  disjoint 
B)  overlap 
C)  partial specialization 
D)  total specialization

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The following figure shows a:

Accepted Answer

A)  disjoint constraint. 
B)  completeness constraint. 
C)  supertype/subtype hierarchy. 
D)  spindle constraint. 
A)  disjoint constraint. 
B)  completeness constraint. 
C)  supertype/subtype hierarchy. 
D)  spindle constraint.

Question 14

An entity cluster is:

Accepted Answer

A)  a formal method for specifying attributes of related entities. 
B)  a set of one or more entity types and associated relationships grouped into a single abstract entity type. 
C)  a useful way to present data for a small and fairly simple organization. 
D)  a way of developing more granular views of the data model. 
A)  a formal method for specifying attributes of related entities. 
B)  a set of one or more entity types and associated relationships grouped into a single abstract entity type. 
C)  a useful way to present data for a small and fairly simple organization. 
D)  a way of developing more granular views of the data model.

Question 15

In packaged data models, strong entities always have ________ between them.

Accepted Answer

A)  weak entities 
B)  1:1 relationships 
C)  1:M relationships 
D)  M:N relationships 
A)  weak entities 
B)  1:1 relationships 
C)  1:M relationships 
D)  M:N relationships

Question 16

The process of defining a more general entity type from a set of more specialized entity types is called:

Accepted Answer

A)  generalization. 
B)  specialization. 
C)  normalization. 
D)  extrapolation. 
A)  generalization. 
B)  specialization. 
C)  normalization. 
D)  extrapolation.

Question 17

Describe how subtype discriminators are used when we have overlapping subtypes.

Accepted Answer

When we have overlapping subty

Question 18

Discuss the reasoning behind using supertype/subtype relationships.

Accepted Answer

It is best to use a supertype/subtype hi

Question 19

The subtype discriminator is a composite attribute when there is a(n):

Accepted Answer

A)  overlap rule. 
B)  disjoint rule. 
C)  partial specialization. 
D)  full specialization. 
A)  overlap rule. 
B)  disjoint rule. 
C)  partial specialization. 
D)  full specialization.

Question 20

Packaged data models use an entity type to store union data.

Accepted Answer

A) True 
 B)False

The following figure is an example of total specialization.

One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same.

Packaged data models cause projects to take more time to build.

The following figure shows an example of:

Which of the following is a completeness constraint?

In the figure shown below, a rental unit can be both an apartment and a house but must be at least one.

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

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.

Explain the terms subtype and supertype. Discuss the differences between them.

In the figure shown below, a rental unit has to be either a house or an apartment.

The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes.

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

The following figure shows a:

An entity cluster is:

In packaged data models, strong entities always have ________ between them.

The process of defining a more general entity type from a set of more specialized entity types is called:

Describe how subtype discriminators are used when we have overlapping subtypes.

Discuss the reasoning behind using supertype/subtype relationships.

The subtype discriminator is a composite attribute when there is a(n):

Packaged data models use an entity type to store union data.

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

The following figure is an example of total specialization.

One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same.

Packaged data models cause projects to take more time to build.

The following figure shows an example of:

Which of the following is a completeness constraint?

In the figure shown below, a rental unit can be both an apartment and a house but must be at least one.

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

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.

Explain the terms subtype and supertype. Discuss the differences between them.

In the figure shown below, a rental unit has to be either a house or an apartment.

The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes.

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

The following figure shows a:

An entity cluster is:

In packaged data models, strong entities always have ________ between them.

The process of defining a more general entity type from a set of more specialized entity types is called:

Describe how subtype discriminators are used when we have overlapping subtypes.

Discuss the reasoning behind using supertype/subtype relationships.

The subtype discriminator is a composite attribute when there is a(n):

Packaged data models use an entity type to store union data.

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