Question 1

Supertype/subtype relationships should not be used when the instances of a subtype participate in no relationships which are unique to that subtype.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

Subtypes that are lower in the

Question 3

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 4

The total specialization rule states that an entity instance of a supertype is allowed not to belong to any subtype.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Why are packaged data models gaining popularity?

Accepted Answer

Most organizations can no longer afford

Question 9

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.

Accepted Answer

A) True 
 B)False

Question 10

In the figure shown below, there could be an instance of a rental unit that is neither an apartment nor a house.

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

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 13

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.

Accepted Answer

A) True 
 B)False

Question 14

Packaged data models are meant to be customized.

Accepted Answer

A) True 
 B)False

Question 15

Specialization is the reverse of generalization.

Accepted Answer

A) True 
 B)False

Question 16

Data models of an existing database are harder for data modelers to read.

Accepted Answer

A) True 
 B)False

Question 17

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 18

All of the following are steps to using a packaged data model EXCEPT:

Accepted Answer

A)  identify the parts of the data model that apply to your data modeling situation. 
B)  utilize all business rules that come with the packaged data model. 
C)  rename the identified data elements. 
D)  map data to be used in packages with existing data in the current databases. 
A)  identify the parts of the data model that apply to your data modeling situation. 
B)  utilize all business rules that come with the packaged data model. 
C)  rename the identified data elements. 
D)  map data to be used in packages with existing data in the current databases.

Question 19

You will never need to map data in current databases to data in a packaged data model.

Accepted Answer

A) True 
 B)False

Question 20

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.

Supertype/subtype relationships should not be used when the instances of a subtype participate in no relationships which are unique to that subtype.

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

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

The total specialization rule states that an entity instance of a supertype is allowed not to belong to any subtype.

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

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.

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

Why are packaged data models gaining popularity?

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.

In the figure shown below, there could be an instance of a rental unit that is neither an apartment nor a house.

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.

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

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.

Packaged data models are meant to be customized.

Specialization is the reverse of generalization.

Data models of an existing database are harder for data modelers to read.

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

All of the following are steps to using a packaged data model EXCEPT:

You will never need to map data in current databases to data in a packaged data model.

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

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

Supertype/subtype relationships should not be used when the instances of a subtype participate in no relationships which are unique to that subtype.

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

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

The total specialization rule states that an entity instance of a supertype is allowed not to belong to any subtype.

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

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.

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

Why are packaged data models gaining popularity?

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.

In the figure shown below, there could be an instance of a rental unit that is neither an apartment nor a house.

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.

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

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.

Packaged data models are meant to be customized.

Specialization is the reverse of generalization.

Data models of an existing database are harder for data modelers to read.

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

All of the following are steps to using a packaged data model EXCEPT:

You will never need to map data in current databases to data in a packaged data model.

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

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