Mis Chapter 5

Chapter 5
Foundations of Business Intelligence:   Database and Information Management

Student Objectives

1. Describe how a relational database organizes data and compare its approach to an object-oriented database.
2. Identify and describe the principles of a database management system.
3. Evaluate tools and technologies for providing information from databases to improve business performance and decision making.
4. Assess the role of information policy and data administration in the management of organizational data resources.
5. Assess the importance of data quality assurance for the business.

Chapter Outline
5.1 The Database Approach to Data Management
Entities and Attributes
Organizing Data in a Relational Database
Establishing Relationships
5.2 Database Management System
Operations of a Relational DBMS
Capabilities of Database Management Systems
Object-Oriented Databases
5.3 Using Databases to Improve Business Performance and Decision Making
Data Warehouses
What is a Data Warehouse?
Data Marts
Business Intelligence, Multidimensional Data Analysis, and Data Mining
Data Mining
Databases and the Web
5.4 Managing Data Resources
Establishing an Information Policy
Ensuring Data Quality
5.5 Hands-On MIS

Key Terms

The following alphabetical list identifies the key terms discussed in this chapter.   The page number for each key term is provided.

Attributes, 160 Entity-relationship diagram, 162
Business intelligence (BI), 171 Field, 161
Data administration, 179 Foreign key, 162
Data cleansing, 180 Information policy, 178
Data definition language, 166 Key field, 161
Data dictionary, 166 Normalization, 163
Data manipulation language, 168 Object-oriented DBMS, 169
Data mart, 170 Object-relational DBMS, 169
Data mining, 173 Online analytical processing (OLAP), 172
Data quality audit, 180 Predictive analysis, 174
Data warehouse, 170 Primary key, 161
Database, 159 Records, 161
Database...