Chapter 5
Foundations of Business Intelligence: Database and
Information Management
Student Learning Objectives
1. How does a relational database organize data, and how does it differ from an object-oriented database?
2. What are the principles of a database management system?
3. What are the principal tools and technologies for accessing information from databases to improve business performance and decision making?
4. What is the role of information policy and data administration in the management of organizational data resources?
5. Why is data quality assurance so important for a business?
Chapter Outline
5.1 The Database Approach to Data Management
Entities and Attributes Organizing Data in a Relational
…show more content…
The opening vignette, “Banco de Credito del Peru Banks on Better Data Management,” describes the difficulties the organization experienced trying to provide its managers and employees with accurate, current, and complete information. Most of the trouble was a result of having isolated systems that were time-consuming and expensive to update and use. Because the data were not consolidated into one system, many times the same piece of data were entered multiple times without any consistency. That led to conflicts and inaccurate reporting.
Only be consolidating and integrating the data were the problems resolved. Most of the problems this organization faced are common throughout the business world. This chapter explores how to correct and prevent these kinds of situations and how digital firms can use database technologies to increase their competitive advantages.
Section 5.1, “The Database Approach to Data Management” Introduces basic key terms like field, record, file, database, entity, and attribute. Try using a simple spreadsheet print-out to demonstrate these terms. If you have access to a relational DBMS during class time, you can demonstrate several of the concepts presented in this section. If you have time and as a class activity, ask your students to prepare an entity-relationship
The use of huge databases that combine all of a company 's data and allow users to access the data directly, create reports, and obtain responses to what-if questions is referred to as:
For this assignment, you will NOT create a database. You will list the type of data you want to collect, group it accordingly, break it into field and determine attributes. Think about how the different pieces of data relate to one another and what purpose they serve. You may use Excel, Word, or Visio for this assignment.
* Describe the role of databases and database management systems in managing organizational data and information.
A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity.
Read the textbook. Do research on databases. All answers should be analytical, using IGEA and MLA. Please use own words/original thought, not regurgitation of facts. This is the expectation all year.
The theme of this book is how businesses in today’s world use ever-improving technology to collect data, convert it into information and business intelligence, and combine this information and intelligence with the knowledge of the workers to help make the best decisions they possibly can for the benefit of the company and the customers. Throughout the book, there are discussions on the different ways that technology can help a business with this process. When going into detail about the various information systems, this book also brings into
One of the main components of a database is characters. Characters are letters, numbers and punctuation marks. You are using characters when you are typing a sentence for example. Another main component would be fields. Fields separate data in defined fields. When data is being entered even if you don’t have an answer for all fields a space is still left but it would be blank. If you have ever seen an excel spreadsheet that would give you an idea of how data is lined out into different fields. Records are a main database component as well. Records are a group of fields that are about one thing. An example would be social security numbers in a database of patients. Each patient would have a social security number and each social security number is in a field. That field would have the same information which is that patients social security number even though every ones is different and there would be many listed depending on how many patients was in the database. Gartee, R. (2011).
Why are databases important to business? How do databases generate sales and-or profits? What databases do you interact with, and how do they benefit you?
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.
Technology trends are related to the widespread adoption of mobile platforms, the Green IT movement, the open source software, cloud computing and the digital data genesis phenomena. the amount of data that is used everyday speaks to the way that companies are evolving and businesses are updating. Our wiki will focus on the latest trend: the Digital Data Genesis and it 's impact on the MGM Grand Casino-Las Vegas (Taylor). (Alyssa-Edited) Digital data can provide new opportunities for firms. Companies may have to deal with a high volume of transactional data, “capturing trillions of bytes of information about their customers and operations” (Vitari and Raguseo, p. 76) (Taylor). “Millions of sensors are embedded in the physical world in devices such as mobile phones, smart energy meters, automobiles, and industrial machines that sense, create and communicate data in the digitalized age”. (Vitari and Raguseo, p. 78) (Taylor). DDG further explained: When a process is “digitalized (e.g., a purchasing of a good on the Internet), it is carried out through a digital computer or device. When an entity is digitalized (e.g., an RFID-enabled good track), the company has the ability to access an informational representation of that entity (e.g., the position of a good along the supply chain), and generate relevant data from it” (Vitari and Raguseo, p. 84) (Taylor). . All of the data is generated in digital forms. To understand this concept, consider three examples, “ the usage of RFID
The authors consist of Robert Miller, Kristine Parsons and David Lifer. Robert Miller is in charge of Business Information systems at Central Michigan University. While Kristine Parsons and David Lifer are apart of the Accounting/ MIS program at Ashland University.
On February 10th 1997, Frank Miller assumed the position as the director of data management in Smith’s Information Services department. He was hired to fill a vacancy that was available for more than one year as well as help restructure and reorganize Smith’s Information Services department (Hattersley and Mcjannet, 54). The primary function of the Data Management Group at Smith Financial was to manage the distribution, storage, capture and flow of data throughout the company. Before Miller, this position was left vacant and needed someone to take charge as well as help the company move in a different direction than the current one.
3. What would you recommend as effective methods for this organisation to store the data, and why? (Give two different options)
Finally, after realising the seriousness of the issue the President of Toyota Motors insisted for a centralised database management, with all customers’ records being stored in a single database. Although it seems to be a very easy task to collect all the records from different locations and then compiling it in a single database, but it was not as simple and easy for Toyota because it involved a series of data management processes.