Exam 12: View Design and Integration

Which of the following should exist in the ERD derived from a form?

In a large database development effort,the process of merging views covering different parts of the database into one complete conceptual schema is called ____________________.

The complexity of an individual database can be measured by the size of its _____________.

View design and integration uses the _____________________ strategy to manage the complexity of a large database design effort.

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) -The structure of the form is:

With the _________________ approach to view integration,a view and a partially integrated ERD are merged in each integration step.

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. -Which of the following groups of names would be considered not to contain synonyms,for which one unique name should be chosen?

The incremental approach to view integration has more steps than the parallel approach,but the steps are smaller.

Requirements are easy to capture.Users can always clarify their requirements without the need to experience a system.

Conflicts arising from different uses of fields and timing differences are resolved sooner in the _____________ approach to view integration.

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. -Which of the following groups of names would be considered to be homonyms?

The consistency rules for relationship cardinalities state that in at least one direction,the maximum cardinality should be ______________ for relationships connecting entity types from the same node.

When using a form-driven approach to database design,form definitions need to be as complete as possible,including a detailed list of the entire set of events which define user interaction with the form.

Data entry forms can be an important source of requirements for a database design.

The _______________ approach to view integration works best when the views are closely related.

In the third step of form analysis,_______________ are attached to the entity types identified in the second step of the process.

In a parent node,how is the node key value unique? ______________________

In an organization whose business is processing customer orders,OrdNo,OrdNum,and Order Number are probably homonyms.

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

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) -The form primary key is: