Question 1

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 D

Question 2

The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes.

Accepted Answer

A) True 
 B)False  True

Question 3

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Explain what entity clustering is.

Accepted Answer

An entity cluster is a group of entities

Question 6

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

Accepted Answer

A)  disjoint 
B)  specialization 
C)  generalization 
D)  overlap 
A)  disjoint 
B)  specialization 
C)  generalization 
D)  overlap

Question 7

Which of the following is a generic entity type that has a relationship with one or more subtypes?

Accepted Answer

A)  Megatype 
B)  Supertype 
C)  Subgroup 
D)  Class 
A)  Megatype 
B)  Supertype 
C)  Subgroup 
D)  Class

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Discuss how attribute inheritance works in a supertype/subtype hierarchy.

Accepted Answer

Subtypes that are lower in the

Question 10

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)  extrapulation. 
A)  generalization. 
B)  specialization. 
C)  normalization. 
D)  extrapulation.

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

Which of the following statements is true about the figure shown below?

Accepted Answer

A)  A rental unit must be either an apartment or a house, and cannot be both at the same time. 
B)  A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time. 
C)  A rental unit must be either an apartment or a house, and could be both. 
D)  A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time. 
A)  A rental unit must be either an apartment or a house, and cannot be both at the same time. 
B)  A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time. 
C)  A rental unit must be either an apartment or a house, and could be both. 
D)  A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time.

Question 15

In a supertype/subtype hierarchy, each subtype has:

Accepted Answer

A)  only one supertype. 
B)  many supertypes. 
C)  at most two supertypes. 
D)  at least one subtype. 
A)  only one supertype. 
B)  many supertypes. 
C)  at most two supertypes. 
D)  at least one subtype.

Question 16

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 17

In the figure shown below, a rental unit can be both a house and an apartment.

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

A subtype is an entity which represents

Question 20

Which statement is true about the following diagram?

Accepted Answer

A)  A person can only be a faculty, student or staff. 
B)  A student can be both an undergraduate and a graduate student at the same time. 
C)  All attributes of person and student are inherited by undergraduate. 
D)  All attributes of graduate are inherited by person. 
A)  A person can only be a faculty, student or staff. 
B)  A student can be both an undergraduate and a graduate student at the same time. 
C)  All attributes of person and student are inherited by undergraduate. 
D)  All attributes of graduate are inherited by person.

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

The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes.

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype.

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

Explain what entity clustering is.

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

Which of the following is a generic entity type that has a relationship with one or more subtypes?

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

Discuss how attribute inheritance works in a supertype/subtype hierarchy.

The process of defining a more general entity type from a set of more specialized entity types 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.

Packaged data models:

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

Which of the following statements is true about the figure shown below?

In a supertype/subtype hierarchy, each subtype has:

Which of the following is a completeness constraint?

In the figure shown below, a rental unit can be both a house and an apartment.

The following figure shows a:

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

Which statement is true about the following diagram?

The Database Environment and Development Process

Modeling Data in the Organization

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 3: The Enhanced E-R Model

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

The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes.

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype.

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

Explain what entity clustering is.

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

Which of the following is a generic entity type that has a relationship with one or more subtypes?

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

Discuss how attribute inheritance works in a supertype/subtype hierarchy.

The process of defining a more general entity type from a set of more specialized entity types 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.

Packaged data models:

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

Which of the following statements is true about the figure shown below?

In a supertype/subtype hierarchy, each subtype has:

Which of the following is a completeness constraint?

In the figure shown below, a rental unit can be both a house and an apartment.

The following figure shows a:

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

Which statement is true about the following diagram?

The Database Environment and Development Process

Modeling Data in the Organization

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters