Exam

Only available on StudyMode
  • Download(s) : 10
  • Published : May 7, 2013
Open Document
Text Preview
Management Information Systems
MANAGING THE DIGITAL FIRM, 12TH EDITION GLOBAL EDITION

Chapter 6
FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT

Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT

Learning Objectives

• Describe how the problems of managing data resources in a traditional file environment are solved by a database management system • Describe the capabilities and value of a database management system • Apply important database design principles • Evaluate tools and technologies for accessing information from databases to improve business performance and decision making • Assess the role of information policy, data administration, and data quality assurance in the management of a firm’s data resources 2 © Pearson Education 2012

Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT

Organizing Data in a Traditional File Environment

• File organization concepts
– – – – Database: Group of related files File: Group of records of same type Record: Group of related fields Field: Group of characters as word(s) or number • Describes an entity (person, place, thing on which we store information) • Attribute: Each characteristic, or quality, describing entity – E.g., Attributes Date or Grade belong to entity COURSE

3 © Pearson Education 2012

Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT

Organizing Data in a Traditional File Environment
THE DATA HIERARCHY
A computer system organizes data in a hierarchy that starts with the bit, which represents either a 0 or a 1. Bits can be grouped to form a byte to represent one character, number, or symbol. Bytes can be grouped to form a field, and related fields can be grouped to form a record. Related records can be collected to form a file, and related files can be organized into a database.

FIGURE 6-1

4

© Pearson Education 2012

Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT

Organizing Data in a Traditional File Environment

• Problems with the traditional file environment (files maintained separately by different departments) – Data redundancy:

– Data inconsistency:

• Presence of duplicate data in multiple files • Same attribute has different values • When changes in program requires changes to data accessed by program

– Program-data dependence:

– Lack of flexibility – Poor security – Lack of data sharing and availability 5 © Pearson Education 2012

Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT

Organizing Data in a Traditional File Environment
TRADITIONAL FILE PROCESSING

FIGURE 6-2

The use of a traditional approach to file processing encourages each functional area in a corporation to develop specialized applications. Each application requires a unique data file that is likely to be a subset of the master file. These subsets of the master file lead to data redundancy and inconsistency, processing inflexibility, and wasted storage resources.

6

© Pearson Education 2012

Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT

The Database Approach to Data Management

• Database
– Serves many applications by centralizing data and controlling redundant data

• Database management system (DBMS)
– Interfaces between applications and physical data files – Separates logical and physical views of data – Solves problems of traditional file environment • • • •
7

Controls redundancy Eliminates inconsistency Uncouples programs and data Enables organization to centrally manage data and data security © Pearson Education 2012

Management Information Systems
CHAPTER 6:...
tracking img