Exam 12: View Design and Integration

In the view design process,in addition to forms,list one of the other sources a designer can use to determine the requirements of the database.______________________

(Essay)

4.7/5

(50)

Question 61

Name one of the things that can be useful in the identification and resolution of synonyms and homonyms.____________________

(Essay)

4.8/5

(33)

Question 62

In the design of a large ERD,views are integrated in one large ERD for the conceptual schema.

(True/False)

4.9/5

(40)

Question 63

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) -You are told that there is an entity type called Reservation.Which of the following lists contains most or all the attributes of Reservation without unnecessary attributes?

(Multiple Choice)

4.8/5

(37)

Question 64

List one of the factors that contribute to the complexity of an organization. _________________

(Short Answer)

4.8/5

(28)

Question 65

Form analysis is a linear process and the steps involved are best performed sequentially,without any backtracking.

(True/False)

4.8/5

(43)

Question 66

During form analysis,to resolve questions about the cardinality between derived entity types you should examine additional form instances and ___________________

(Short Answer)

4.9/5

(41)

Question 67

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) -Reservation is:

(Multiple Choice)

4.7/5

(36)

Question 68

View integration can be more complex with the incremental approach.

(True/False)

4.9/5

(41)

Question 69

The parallel approach to view integration is appropriate for views that are closely related,such as an order and an invoice.

(True/False)

4.8/5

(29)

Question 70

If form A must be completed before form B is used,and form A must be completed before form C is used,there is a precedence relationship between A and B,and between A and C,but not between B and C.

(True/False)

4.9/5

(29)

Question 71

A __________ is a group of words that are spelled differently but have the same meaning

(Multiple Choice)

4.8/5

(30)

Question 72

In a large database development effort,the process of constructing an ERD for each group of users is called ____________________.

(Short Answer)

4.8/5

(28)

Question 73

On a large project with many database developers,the ________________ approach to view integration supports more independent work.

(Short Answer)

4.8/5

(33)

Question 74

It is possible to group form fields into entity types by analyzing functional dependencies.

(True/False)

4.8/5

(32)

Question 75

In view design,an ERD representing a form is the output of the __________________ process.

(Short Answer)

4.8/5

(44)

Question 76

Showing 61 - 76 of 76

In the view design process,in addition to forms,list one of the other sources a designer can use to determine the requirements of the database.______________________

Name one of the things that can be useful in the identification and resolution of synonyms and homonyms.____________________

In the design of a large ERD,views are integrated in one large ERD for the conceptual schema.

List one of the factors that contribute to the complexity of an organization. _________________

Form analysis is a linear process and the steps involved are best performed sequentially,without any backtracking.

During form analysis,to resolve questions about the cardinality between derived entity types you should examine additional form instances and ___________________

View integration can be more complex with the incremental approach.

The parallel approach to view integration is appropriate for views that are closely related,such as an order and an invoice.

If form A must be completed before form B is used,and form A must be completed before form C is used,there is a precedence relationship between A and B,and between A and C,but not between B and C.

A __________ is a group of words that are spelled differently but have the same meaning

In a large database development effort,the process of constructing an ERD for each group of users is called ____________________.

On a large project with many database developers,the ________________ approach to view integration supports more independent work.

It is possible to group form fields into entity types by analyzing functional dependencies.

In view design,an ERD representing a form is the output of the __________________ process.

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