preview

Wildwood

Better Essays

Chapter 2 Solution Manual
Outcomes
* Review documents to discover relevant entities and attributes for database * Prepare interview questions and follow up * Prepare questionnaires * Observe work flow for process and exceptions
Outline
I. Gathering Information A. Initial Interviews with Chief Stakeholders B. Review of Business Documents C. Interviews with Stakeholders D. Questionnaires E. Job Shadowing
II. Review of Business Documents A. Reasons for Review B. Forms C. Reports D. Other Business Documents
III. Types of Databases A. Transaction Database B. Management Information Systems C. Business Intelligence Systems D. Cloud Databases
IV. Interviews with Stakeholders A. Preparing for the …show more content…

The workshops should be carefully organized and professionally facilitated. It could work for database development. 3. Search for an article on Database Design. Does it have any discussion of information gathering? If so, what steps does it suggest?
The Wikipedia article http://en.wikipedia.org/wiki/Database_design specifically mentions information gathering. It does offer some suggestions, such as cooperating with a person who is expert in the knowledge domain—a biologist, for instance, for a database storing biological data. The article “Ten Common Database Design Mistakes” http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/ also notes the crucial nature of careful information gathering at the start of the process. The article’s author suggests taking the time needed to gather complete and correct information. 4. What does the term Business Intelligence mean? What tools does the Microsoft Business Intelligence suite that ships with SQL Server contain? Wikipedia, http://en.wikipedia.org/wiki/Business_intelligence, defines business intelligence as “computer based techniques used in spotting, digging out and analyzing business data.” SQL Server’s Business Intelligence tools include the Reporting Services, Analysis Services, and Integration Services among others. A complete overview can be found at

Get Access