Exam
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
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