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
Prior to designing my database, I will have a clear understanding of the data. This will allow me to determine the purpose of the database. Once all information is
Review each database or collection to gather information to create a description for the assignment. Each description must:
| I would address the team members and ask were there any funds unaccounted for
Database tools and technologies affected the business processes and decision making by a great extent. The most important benefit of the database is to change unstructured information into structured information, and allow users to analysis the data stored into different tables with the help of queries. Before database, all the information used to stored into paper and other unstructured computer programs, due to which getting required information process was very slow. Due to database, all the
Business intelligence (BI) merges architectures, tools, databases, analytical tools, applications, and methodologies. It also is context free like DSS. BI deduces the connections between business entities by evaluating copious volumes of historical data which supports decisions. BI has four major components consisting of a data warehouse, business analytics, business performance management, and a user interface.
9. SQL - You may have to understand what a query is doing, and what results will generated from a query. You will need to evaluate why a query may not execute. You will not have to write SQL queries.
There are several important steps to consider when designing a database, as a well-designed database should be deployed and not only support the accuracy and integrity of business information but also avoid redundant data and assist with has enterprise level reporting tasked. If we analyze the
You understand that database technology can dramatically improve your ability to analyze information, compared to spreadsheet technology, and assist you in developing your strategic plans for the cafe. To help you familiarize yourself with databases and their associated business value you need to create a report detailing the basics of databases and why they are better for running a business than spreadsheet applications. Be sure to provide a detailed explanation of relational databases along with their associated business advantages.
Business Intelligence (BI) is the consolidation and analysis of internal data and / or external data for the purpose of effective decision-making. At the core of all BI initiatives is a data warehouse to hold the data and analytics software. The data warehouse stores data from operational systems in the organization and restructures it to enable queries and models to extract decision support reports.
Business intelligence covers some pretty important topics to Varco Pruden Buildings. It mainly deals with entry level knowledge and skills that many have gathered and picked up along the course of their lives. Although these may seem pretty easy going, it is of great importance to the company and many of your fellow coworkers. Three of the
Every summer,my family has the tradition of going down to Wildwood Beach for a week . Wildwood is like home to me. There I have countless memories such as riding a huge 12 person bike, ordering zeppoles for breakfast and getting the icecream truck at midnight every year. The beach is where we all saw my baby cousin's first steps and where I went on walks during sunset with my papa before he passed. Every year we all count down the days to be down there, all together, to make even more memories. The beach represents me in so many ways . I love the feeling of the sand on my feet and the calmness I get being
It should be a user friendly as possible so as to eliminate the previous problems
As we discuss the possibility of emerging into business intelligence software we must keep in mind the overall purpose of using any type of software is to reach strategic goals in order to increase market shares. I will discuss how business intelligence software will allow us to meet those strategic goals. We will establish what type of information and analysis capabilities will be available once this business intelligence software is implemented. We will discuss hardware and system software that will be required to run specific business intelligence software. Lastly, I will give a brief synopsis on three vendors (IBM, Microsoft Microsoft and Oracle) that are dominating the business information software
Business Intelligence: Business intelligence is a program that coordinates the best combinations of data in sales to achieve maximum profits.
R.L Fielding (2008) reiterates that Business Intelligence is a thorough and holistic analysis of the company records, data, information, and software application for effective decision making. All decision making processes need an organized, readily-accessible, and human readable compilations of data. With the use of an effective tool the firm can easily figure out their own business processes, the behavior of their customers, and the economic trend of the industry. With these facts, the firm can arrive at a better strategy to achieve their specified goals with confidence.