Question 1

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 2

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 3

The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

An entity cluster should focus on some area of interest to some community of users,developers or managers.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Contrast the overlap rule to the disjoint rule.

Accepted Answer

The disjoint rule is used when you wish

Question 8

The ________ specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

Accepted Answer

total spec

Question 9

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 10

A supertype/subtype hierarchy is an arrangement of supertypes and subtypes where each ________ has only one ________.

Accepted Answer

The answer of A supertype/subtype hierarchy is an arrangement of...

Question 11

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

Accepted Answer

The business environment has drastically

Question 12

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 13

An attribute of the supertype whose values determine the target subtype(s)is called a(n)________.

Accepted Answer

subtype di

Question 14

A subtype can become a supertype if the subtype has other subtypes beneath it.

Accepted Answer

A) True 
 B)False

Question 15

A(n)________ is a set of one or more entity types and associated relationships grouped into a single abstract entity type.

Accepted Answer

The answer of A(n)________ is a set of one or...

Question 16

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 17

An attribute of the supertype that determines the target subtype(s)is called the:

Accepted Answer

A)  determinant. 
B)  subtype decision. 
C)  disjoint indicator. 
D)  none of the above. 
A)  determinant. 
B)  subtype decision. 
C)  disjoint indicator. 
D)  none of the above.

Question 18

Specialization is the reverse of generalization.

Accepted Answer

A) True 
 B)False

Question 19

In the figure below,which of the following are subtypes of patient?

Accepted Answer

A)  Outpatient 
B)  Physician 
C)  Bed 
D)  All of the above 
A)  Outpatient 
B)  Physician 
C)  Bed 
D)  All of the above

Question 20

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.

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

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

The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

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

An entity cluster should focus on some area of interest to some community of users,developers or managers.

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

Contrast the overlap rule to the disjoint rule.

The ________ specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

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

A supertype/subtype hierarchy is an arrangement of supertypes and subtypes where each has only one .

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

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

An attribute of the supertype whose values determine the target subtype(s)is called a(n)________.

A subtype can become a supertype if the subtype has other subtypes beneath it.

A(n)________ is a set of one or more entity types and associated relationships grouped into a single abstract entity type.

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.

An attribute of the supertype that determines the target subtype(s)is called the:

Specialization is the reverse of generalization.

In the figure below,which of the following are subtypes of patient?

In a supertype/subtype hierarchy,each subtype has:

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

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 3: The Enhanced E-R Model and Business Rules

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

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

The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

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

An entity cluster should focus on some area of interest to some community of users,developers or managers.

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

Contrast the overlap rule to the disjoint rule.

The ________ specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

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

A supertype/subtype hierarchy is an arrangement of supertypes and subtypes where each ________ has only one ________.

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

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

An attribute of the supertype whose values determine the target subtype(s)is called a(n)________.

A subtype can become a supertype if the subtype has other subtypes beneath it.

A(n)________ is a set of one or more entity types and associated relationships grouped into a single abstract entity type.

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.

An attribute of the supertype that determines the target subtype(s)is called the:

Specialization is the reverse of generalization.

In the figure below,which of the following are subtypes of patient?

In a supertype/subtype hierarchy,each subtype has:

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

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

A supertype/subtype hierarchy is an arrangement of supertypes and subtypes where each has only one .