– Part III
Chapter 11 Database Analysis and the DreamHome Case Study
Review Questions
11.1 Briefly describe what the process of fact-finding attempts to achieve for a database developer.
11.2 Describe how fact-finding is used throughout the stages of the database system development
lifecycle.
11.3 For each stage of the database system development lifecycle identify examples of the facts
captured and the documentation produced.
11.4 A database developer normally uses several fact-finding techniques during a single database
project. The five most commonly used techniques are examining documentation, interviewing,
observing the business in operation, conducting research, and using questionnaires. Describe
each fact-finding technique and identify the advantages and disadvantages of each.
11.5 Describe the purpose of defining a mission statement and mission objectives for a database
system.
11.6 What is the purpose of identifying the systems boundary for a database system?
11.7
specification?
7
11.8 Describe one method to deciding whether to use either the centralized or view integration
approach, or a combination of both when developing a database system for multiple user
views.
Exercises
11.9 Assume that you are an employee of a consultancy company that specializes in the analysis,
design, and implementation of database systems. A client has recently approached your
company with a view to implementing a database system, but they are not familiar with the
development process.
Task: You are required to present an overview of the fact–finding techniques that your
11.10 Assume that you are an employee of a consultancy company that specializes in the analysis,
design, and implementation of database systems. A client has recently approached your
company with a view to implementing a database system.
11.11 Assume that you are an employee of a consultancy company that specializes in the analysis,
design, and implementation of database systems. A client has recently approached your
company with a view to implementing a database system. It has already been established that
s (user views).