Question 1

In which approach does the integration of views involve only two ERDs at a time?

Accepted Answer

A)  Sequential 
B)  Incremental 
C)  Parallel 
D)  Datamart 
A)  Sequential 
B)  Incremental 
C)  Parallel 
D)  Datamart

Question 2

The following is indicative that a ternary relationship between entity types X,Y,and Z should exist in the ERD diagram derived from a form:

Accepted Answer

A)  X is on the main form 
B)  Y and Z are on the subform 
C)  Both Y and Z are updatable 
D)  All of the above 
A)  X is on the main form 
B)  Y and Z are on the subform 
C)  Both Y and Z are updatable 
D)  All of the above

Question 3

Typically each node in a form's hierarchical structure represents only one entity type.

Accepted Answer

A) True 
 B)False

Question 4

In a tools rental business, a form is used to reserve large construction tools for customers (i.e. subcontractors working for a construction company). The following fields appear on the form:
(tool information)
Item#
Type
Descr
Size
Cost/Day
Mfg (Tool manufacturer)
MfgAddr (Manufacturer address)
Mfg phone
(Customer and reservation information)
rental# (rental order number for the tool, unique for a given tool)
CustId
CustName
CustAddress
CustPhone
Checkout_date (future date for a future reservation or past date for a current rental)
Days (Expected length of rental)
ConsName (Construction Company Name)
ConsAddr (Construction Company Address)
Discount (specific to a construction company)

-How many entity types should be identified?

Accepted Answer

A)  2 
B)  3 
C)  4 
D)  at least 5 
A)  2 
B)  3 
C)  4 
D)  at least 5

Question 5

Given two forms A and B,if form A must be completed before form B,this is known as a(n)___________________.

Accepted Answer

precedence

Question 6

In a tools rental business, a form is used to reserve large construction tools for customers (i.e. subcontractors working for a construction company). The following fields appear on the form:
(tool information)
Item#
Type
Descr
Size
Cost/Day
Mfg (Tool manufacturer)
MfgAddr (Manufacturer address)
Mfg phone
(Customer and reservation information)
rental# (rental order number for the tool, unique for a given tool)
CustId
CustName
CustAddress
CustPhone
Checkout_date (future date for a future reservation or past date for a current rental)
Days (Expected length of rental)
ConsName (Construction Company Name)
ConsAddr (Construction Company Address)
Discount (specific to a construction company)

-Which form field does not belong to the child node?

Accepted Answer

A)  CustId 
B)  Discount 
C)  MfgAddr 
D)  Item# 
A)  CustId 
B)  Discount 
C)  MfgAddr 
D)  Item#

Question 7

In the parallel approach to view integration,integration is performed in one large step at the end of the process when all of the views are merged into one final ERD.

Accepted Answer

A) True 
 B)False

Question 8

In a tools rental business, a form is used to reserve large construction tools for customers (i.e. subcontractors working for a construction company). The following fields appear on the form:
(tool information)
Item#
Type
Descr
Size
Cost/Day
Mfg (Tool manufacturer)
MfgAddr (Manufacturer address)
Mfg phone
(Customer and reservation information)
rental# (rental order number for the tool, unique for a given tool)
CustId
CustName
CustAddress
CustPhone
Checkout_date (future date for a future reservation or past date for a current rental)
Days (Expected length of rental)
ConsName (Construction Company Name)
ConsAddr (Construction Company Address)
Discount (specific to a construction company)

-Which form field does not belong to the parent node?

Accepted Answer

A)  Item# 
B)  CustId 
C)  Brand 
D)  MfgAddr 
A)  Item# 
B)  CustId 
C)  Brand 
D)  MfgAddr

Question 9

In the fifth step of form analysis,the ERD is checked against the form structure for ______________ and _______________.

Accepted Answer

completene

Question 10

For any relationship between an entity type derived from the parent node and an entity derived from the child node,this relationship should be M-N or 1-M.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is not true about view design and integration?

Accepted Answer

A)  Integration works if the view designers design non-conflicting views by agreeing on everything before the individual designs are started 
B)  Conflicts exist after the views have been designed 
C)  Conflicts among different views must be resolved as part of the integration process 
D)  Resolving conflicts will require that some views be revised 
A)  Integration works if the view designers design non-conflicting views by agreeing on everything before the individual designs are started 
B)  Conflicts exist after the views have been designed 
C)  Conflicts among different views must be resolved as part of the integration process 
D)  Resolving conflicts will require that some views be revised

Question 12

Which of the following is not a major step found in the form analysis process?

Accepted Answer

A)  Identify entity types 
B)  Identify generalization hierarchies 
C)  Identify relationships 
D)  Check completeness and consistency 
A)  Identify entity types 
B)  Identify generalization hierarchies 
C)  Identify relationships 
D)  Check completeness and consistency

Question 13

In a tools rental business, a form is used to reserve large construction tools for customers (i.e. subcontractors working for a construction company). The following fields appear on the form:
(tool information)
Item#
Type
Descr
Size
Cost/Day
Mfg (Tool manufacturer)
MfgAddr (Manufacturer address)
Mfg phone
(Customer and reservation information)
rental# (rental order number for the tool, unique for a given tool)
CustId
CustName
CustAddress
CustPhone
Checkout_date (future date for a future reservation or past date for a current rental)
Days (Expected length of rental)
ConsName (Construction Company Name)
ConsAddr (Construction Company Address)
Discount (specific to a construction company)

-Which of the following attributes is not a primary key,nor part of a primary key?

Accepted Answer

A)  Item# 
B)  Type 
C)  Mfg 
D)  CustId 
A)  Item# 
B)  Type 
C)  Mfg 
D)  CustId

Question 14

The process of combining individual views into a complete database design is known as _______________________.

Accepted Answer

The answer of The process of combining individual views into...

Question 15

Forms that have precedence relationships should be grouped together in the same view subset.

Accepted Answer

A) True 
 B)False

Question 16

Which one of these characteristics of views would favor the parallel approach?

Accepted Answer

A)  The views are closely related 
B)  The views have significant overlaps 
C)  The views are not closely related 
D)  There are much less database designers than views 
A)  The views are closely related 
B)  The views have significant overlaps 
C)  The views are not closely related 
D)  There are much less database designers than views

Question 17

In a form hierarchy diagram,a rectangle is used to identify a(n)______________.

Accepted Answer

The answer of In a form hierarchy diagram,a rectangle is...

Question 18

The incremental approach to view integration is incremental because a partially integrated ERD is produced after each step in the process.

Accepted Answer

A) True 
 B)False

Question 19

When adding relationships in the fourth step of form analysis,where should the entity type containing the primary key of the form be placed in the ERD? ______________

Accepted Answer

The answer of When adding relationships in the fourth step...

Question 20

The following is indicative that binary relationships only exist among entity types X,Y,and Z found on a form:

Accepted Answer

A)  X is on the subform 
B)  Y and Z are on the subform 
C)  Only X is updatable 
D)  All of the above 
A)  X is on the subform 
B)  Y and Z are on the subform 
C)  Only X is updatable 
D)  All of the above

In which approach does the integration of views involve only two ERDs at a time?

The following is indicative that a ternary relationship between entity types X,Y,and Z should exist in the ERD diagram derived from a form:

Typically each node in a form's hierarchical structure represents only one entity type.

Given two forms A and B,if form A must be completed before form B,this is known as a(n)___________________.

In the parallel approach to view integration,integration is performed in one large step at the end of the process when all of the views are merged into one final ERD.

In the fifth step of form analysis,the ERD is checked against the form structure for and _.

For any relationship between an entity type derived from the parent node and an entity derived from the child node,this relationship should be M-N or 1-M.

Which of the following is not true about view design and integration?

Which of the following is not a major step found in the form analysis process?

The process of combining individual views into a complete database design is known as _______________________.

Forms that have precedence relationships should be grouped together in the same view subset.

Which one of these characteristics of views would favor the parallel approach?

In a form hierarchy diagram,a rectangle is used to identify a(n)______________.

The incremental approach to view integration is incremental because a partially integrated ERD is produced after each step in the process.

When adding relationships in the fourth step of form analysis,where should the entity type containing the primary key of the form be placed in the ERD? ______________

The following is indicative that binary relationships only exist among entity types X,Y,and Z found on a form:

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

Exam 12: View Design and Integration

In which approach does the integration of views involve only two ERDs at a time?

The following is indicative that a ternary relationship between entity types X,Y,and Z should exist in the ERD diagram derived from a form:

Typically each node in a form's hierarchical structure represents only one entity type.

Given two forms A and B,if form A must be completed before form B,this is known as a(n)___________________.

In the parallel approach to view integration,integration is performed in one large step at the end of the process when all of the views are merged into one final ERD.

In the fifth step of form analysis,the ERD is checked against the form structure for ______________ and _______________.

For any relationship between an entity type derived from the parent node and an entity derived from the child node,this relationship should be M-N or 1-M.

Which of the following is not true about view design and integration?

Which of the following is not a major step found in the form analysis process?

The process of combining individual views into a complete database design is known as _______________________.

Forms that have precedence relationships should be grouped together in the same view subset.

Which one of these characteristics of views would favor the parallel approach?

In a form hierarchy diagram,a rectangle is used to identify a(n)______________.

The incremental approach to view integration is incremental because a partially integrated ERD is produced after each step in the process.

When adding relationships in the fourth step of form analysis,where should the entity type containing the primary key of the form be placed in the ERD? ______________

The following is indicative that binary relationships only exist among entity types X,Y,and Z found on a form:

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

In the fifth step of form analysis,the ERD is checked against the form structure for and _.