Deck 12: View Design and Integration

Question 1

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

Answer 1

False
Explanation: Requirements can be notoriously difficult to capture. Users often need to experience a system to clarify their requirements.

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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.

Question 6

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

Question 7

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.

Question 8

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

Question 9

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.

Question 10

View integration can be more complex with the incremental approach.

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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.

Question 16

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.

Question 17

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

Question 18

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.

Question 19

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.

Question 20

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

Question 21

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?

A) Rental#, Days, Checkout_date
B) Rental#, CustId, Days, Checkout_date
C) Rental#, Checkout_date
D) Days, Checkout_date, Mfg

Question 22

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

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 23

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

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

Question 24

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.

Question 25

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

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 26

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

Question 27

How many entity types should be identified?

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

Question 28

Reservation is:

A) An associative entity type
B) An identifying entity type
C) A weak entity type
D) A supertype entity

Question 29

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

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

Question 30

The structure of the form is:

A) Parent node X, child node Y
B) Parent node X, two child nodes Y and Z
C) Parent node X, node Y child to node X and parent to child node Z
D) Nodes X and Y, both parent to child node Z

Question 31

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

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

Question 32

The form primary key is:

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

Question 33

Which form field does not belong to the child node?

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

Question 34

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

Question 35

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

Question 36

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

Question 37

Which form field does not belong to the parent node?

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

Question 38

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

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 39

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

Question 40

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:

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 41

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

A) A relationship must connect the form entity type to another entity type of the parent node
B) A relationship must connect the form entity type to another entity type of the child node
C) A relationship must connect an entity type of the child node to another entity type of the child node
D) All of the above

Question 42

Which of the following groups of names would be considered not to contain synonyms,for which one unique name should be chosen?

A) CUSTOMER and CLIENT
B) EMPID and EMPNO
C) LAST_NAME and LNAME
D) FIRST_NAME and FNAME

Question 43

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

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

Question 44

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:

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

Question 45

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

Question 46

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

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

Question 47

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.______________________

Question 48

Which of the following groups of names would be considered to be homonyms?

A) ADDRESS in CUSTOMER and ADDRESS in CLIENT
B) CID in CUSTOMER and ID in CLIENT
C) LAST_NAME and LNAME
D) All of the above

Question 49

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:

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 50

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

A) synonym
B) homonym
C) cardinality grouping
D) node grouping

Question 51

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

Question 52

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

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

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 58

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

Question 59

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

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

Question 60

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

Question 61

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

Question 62

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.

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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.

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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? ______________

Question 75

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

Question 76

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