Question 1

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 2

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 3

The following figure is an example of:

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

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

Accepted Answer

A)  specialization. 
B)  generalization. 
C)  creating discord. 
D)  selecting classes. 
A)  specialization. 
B)  generalization. 
C)  creating discord. 
D)  selecting classes.

Question 11

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 12

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 13

An entity cluster can be formed by:

Accepted Answer

A)  deleting a supertype and its subtype. 
B)  combining metadata. 
C)  combining a strong entity and its weak entities. 
D)  deleting metadata. 
A)  deleting a supertype and its subtype. 
B)  combining metadata. 
C)  combining a strong entity and its weak entities. 
D)  deleting metadata.

Question 14

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 15

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 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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.

The following figure is an example of:

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

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

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

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

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

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

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.

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.

An entity cluster can be formed by:

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

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.

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.

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

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

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

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

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

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.

The following figure is an example of:

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

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

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

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

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

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

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.

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.

An entity cluster can be formed by:

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

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.

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.

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

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

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

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

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