Question 1

Which of the following statements is true about the ERD derived from a form?

Accepted Answer

A)  If there is one relationship between two entity types derived from the parent node, this relationship should be M-N 
B)  If there is one relationship between two entity types derived from the parent node, this relationship should be 1-M or 1-1 
C)  If there is one relationship between two entity types derived from the parent node, this relationship should be 1-M 
D)  If there is one relationship between two entity types derived from the parent node, this relationship should be 1-1 
A)  If there is one relationship between two entity types derived from the parent node, this relationship should be M-N 
B)  If there is one relationship between two entity types derived from the parent node, this relationship should be 1-M or 1-1 
C)  If there is one relationship between two entity types derived from the parent node, this relationship should be 1-M 
D)  If there is one relationship between two entity types derived from the parent node, this relationship should be 1-1 B

Question 2

To manage complexity,the "divide and conquer" strategy is used in many areas of computing.Dividing a large problem allows smaller problems to be independently solved.

Accepted Answer

A) True 
 B)False  True

Question 3

View1 has entity type CUSTOMER with attributes CID, LAST_NAME, FIRST_NAME, ADDRESS (which includes, number, street, city, state, zip), SALESPERSON, EMPID)
View2 has entity type CLIENT with attributes ID, LNAME, FNAME, ADDRESS (number and street), CITY, STATE, ZIP, CLIENT_SINCE (year), and entity type EMPLOYEE (ELNAME, EFNAME, EMPNO, DNAME). There is a 1-M relationship from EMPLOYEE to CLIENT (an employee may be the salesperson responsible for several customers).
CLIENT and CUSTOMER contain essentially the data for the same customers. In CUSTOMER, SALESPERSON (further identified by EMPID) represents the salesperson (last name, first name) responsible for the customer. It is a foreign key referencing the table EMPLOYEE (primary key: EMPNO). View1 and View2 must be integrated.

-In the integration the entity types CUSTOMER and CLIENT are merged into one entity type,CUSTOMER.Choose the most appropriate group of attributes for this new entity type:

Accepted Answer

A)  CID, LNAME, FNAME, FULL_ADDRESS, SALESPERSON_LNAME, SALESPERSON_FNAME 
B)  CID, LNAME, FNAME, FULL_ADDRESS, EMPID 
C)  CID, LNAME, FNAME, FULL_ADDRESS, EMPID. 
D)  CID, LNAME, FNAME, ADDRESS, CITY, STATE, ZIP, CUSTOMER_SINCE 
A)  CID, LNAME, FNAME, FULL_ADDRESS, SALESPERSON_LNAME, SALESPERSON_FNAME 
B)  CID, LNAME, FNAME, FULL_ADDRESS, EMPID 
C)  CID, LNAME, FNAME, FULL_ADDRESS, EMPID. 
D)  CID, LNAME, FNAME, ADDRESS, CITY, STATE, ZIP, CUSTOMER_SINCE D

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)

-To actually identify a Reservation entity,the following attributes are required:

Accepted Answer

A)  Rental# 
B)  Rental#, Item# 
C)  Rental#, Item#, CustId 
D)  Rental#, CustId 
A)  Rental# 
B)  Rental#, Item# 
C)  Rental#, Item#, CustId 
D)  Rental#, CustId

Question 5

When adding relationships in the fourth step of form analysis,after you identify the form entity type,you should add 1-M relationships with the other entity types derived from fields in the main form.

Accepted Answer

A) True 
 B)False

Question 6

In database design,a(n)__________________ occurs when different parts of the organization use different vocabulary to describe the same things.

Accepted Answer

The answer of In database design,a(n)__________________ occurs when different parts...

Question 7

Since they occur infrequently in most organizations,resolving synonyms and homonyms is seldom an important issue in database development.

Accepted Answer

A) True 
 B)False

Question 8

Identifying precedence relationships among forms is performed during the view design phase of database development.

Accepted Answer

A) True 
 B)False

Question 9

The consistency rules for relationship cardinalities state that in at least one direction,the maximum cardinality should be ______________ for relationships connecting entity types derived from nodes on different levels of the form hierarchy.

Accepted Answer

The answer of The consistency rules for relationship cardinalities state...

Question 10

An ERD for a large database typically has no more than 50 entity types and relationships.

Accepted Answer

A) True 
 B)False

Question 11

The complexity of a database reflects the complexity of the underlying organization and the functions that a database supports.Factors can contribute to the complexity of an organization are:

Accepted Answer

A)  size of the organization and/or its organizational structure 
B)  the organization's regulatory environment 
C)  the organization's competitive environment 
D)  all of the above 
A)  size of the organization and/or its organizational structure 
B)  the organization's regulatory environment 
C)  the organization's competitive environment 
D)  all of the above

Question 12

Which of the following is typically true about the child node key?

Accepted Answer

A)  The child node key is unique among all form instances 
B)  The child node key is often the primary key of an entity 
C)  The child node key may not be used as part of the primary key in another entity 
D)  All of the above 
A)  The child node key is unique among all form instances 
B)  The child node key is often the primary key of an entity 
C)  The child node key may not be used as part of the primary key in another entity 
D)  All of the above

Question 13

A(n)_________________ is a mix of incremental and parallel approaches to integrate a set of views.

Accepted Answer

integratio

Question 14

The use of forms in view design precludes gathering requirements in other formats such as interviews and documentation of an existing system.

Accepted Answer

A) True 
 B)False

Question 15

If a form contains only a primary key,a separate entity type may not be created.

Accepted Answer

A) True 
 B)False

Question 16

Dividing the views into subsets that are closely related,and then applying the incremental approach to each subset is an example of an integration strategy for a large database design effort.

Accepted Answer

A) True 
 B)False

Question 17

In a typical integration strategy,parallel integration is applied to the ERDs that have resulted from integrating view subsets,in order to produce a final,integrated ERD for the database.

Accepted Answer

A) True 
 B)False

Question 18

To be useful in view design a form needs at a minimum the following feature:

Accepted Answer

A)  The complete user interaction with the form must be known 
B)  The form may be an incomplete sketch on a word processor 
C)  The form must have been implemented on the computer system 
D)  The form must contain all the information needed for the design 
A)  The complete user interaction with the form must be known 
B)  The form may be an incomplete sketch on a word processor 
C)  The form must have been implemented on the computer system 
D)  The form must contain all the information needed for the design

Question 19

In database design,a(n)_________________ occurs when the usage context of the same term varies between forms.

Accepted Answer

The answer of In database design,a(n)_________________ occurs when the usage...

Question 20

To resolve synonyms and homonyms,you would rename the homonyms to the same term,and rename the synonyms to different terms.

Accepted Answer

A) True 
 B)False

Which of the following statements is true about the ERD derived from a form?

To manage complexity,the "divide and conquer" strategy is used in many areas of computing.Dividing a large problem allows smaller problems to be independently solved.

When adding relationships in the fourth step of form analysis,after you identify the form entity type,you should add 1-M relationships with the other entity types derived from fields in the main form.

In database design,a(n)__________________ occurs when different parts of the organization use different vocabulary to describe the same things.

Since they occur infrequently in most organizations,resolving synonyms and homonyms is seldom an important issue in database development.

Identifying precedence relationships among forms is performed during the view design phase of database development.

The consistency rules for relationship cardinalities state that in at least one direction,the maximum cardinality should be ______________ for relationships connecting entity types derived from nodes on different levels of the form hierarchy.

An ERD for a large database typically has no more than 50 entity types and relationships.

The complexity of a database reflects the complexity of the underlying organization and the functions that a database supports.Factors can contribute to the complexity of an organization are:

Which of the following is typically true about the child node key?

A(n)_________________ is a mix of incremental and parallel approaches to integrate a set of views.

The use of forms in view design precludes gathering requirements in other formats such as interviews and documentation of an existing system.

If a form contains only a primary key,a separate entity type may not be created.

Dividing the views into subsets that are closely related,and then applying the incremental approach to each subset is an example of an integration strategy for a large database design effort.

In a typical integration strategy,parallel integration is applied to the ERDs that have resulted from integrating view subsets,in order to produce a final,integrated ERD for the database.

To be useful in view design a form needs at a minimum the following feature:

In database design,a(n)_________________ occurs when the usage context of the same term varies between forms.

To resolve synonyms and homonyms,you would rename the homonyms to the same term,and rename the synonyms to different terms.

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

Which of the following statements is true about the ERD derived from a form?

To manage complexity,the "divide and conquer" strategy is used in many areas of computing.Dividing a large problem allows smaller problems to be independently solved.

When adding relationships in the fourth step of form analysis,after you identify the form entity type,you should add 1-M relationships with the other entity types derived from fields in the main form.

In database design,a(n)__________________ occurs when different parts of the organization use different vocabulary to describe the same things.

Since they occur infrequently in most organizations,resolving synonyms and homonyms is seldom an important issue in database development.

Identifying precedence relationships among forms is performed during the view design phase of database development.

The consistency rules for relationship cardinalities state that in at least one direction,the maximum cardinality should be ______________ for relationships connecting entity types derived from nodes on different levels of the form hierarchy.

An ERD for a large database typically has no more than 50 entity types and relationships.

The complexity of a database reflects the complexity of the underlying organization and the functions that a database supports.Factors can contribute to the complexity of an organization are:

Which of the following is typically true about the child node key?

A(n)_________________ is a mix of incremental and parallel approaches to integrate a set of views.

The use of forms in view design precludes gathering requirements in other formats such as interviews and documentation of an existing system.

If a form contains only a primary key,a separate entity type may not be created.

Dividing the views into subsets that are closely related,and then applying the incremental approach to each subset is an example of an integration strategy for a large database design effort.

In a typical integration strategy,parallel integration is applied to the ERDs that have resulted from integrating view subsets,in order to produce a final,integrated ERD for the database.

To be useful in view design a form needs at a minimum the following feature:

In database design,a(n)_________________ occurs when the usage context of the same term varies between forms.

To resolve synonyms and homonyms,you would rename the homonyms to the same term,and rename the synonyms to different terms.

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