FOUNDATIONS OF BUSINESS INTELLIGENCE:

2052 Words9 Pages
Management Information Systems
MANAGING THE DIGITAL FIRM, 12TH EDITION

Chapter 6
FOUNDATIONS OF BUSINESS
INTELLIGENCE: DATABASES AND
INFORMATION MANAGEMENT

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

RR Donnelley Tries to Master Its Data

• Problem: Explosive growth created information management challenges.
• Solutions: Use MDM to create an enterprise‐wide set of data, preventing unnecessary data duplication.
• Master data management (MDM) enables companies like
R.R. Donnelley to eliminate outdated, incomplete or incorrectly formatted data.
• Demonstrates IT’s role in successful data management.
• Illustrates digital technology’s role in
…show more content…
Illustrated here are two possible views, one of interest to a benefits specialist and one of interest to a member of the company’s payroll department.

© Prentice Hall 2011

4

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

The Database Approach to Data Management

• Relational DBMS
– Represent data as two‐dimensional tables called relations or files – Each table contains data on entity and attributes

• Table: grid of columns and rows
– Rows (tuples): Records for different entities
– Fields (columns): Represents attribute for entity
– Key field: Field used to uniquely identify each record
– Primary key: Field in table used for key fields
– Foreign key: Primary key used in second table as look‐up field to identify records from original table
9

© Prentice Hall 2011

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

The Database Approach to Data Management
RELATIONAL DATABASE TABLES

FIGURE 6‐4

10

A relational database organizes data in the form of two‐dimensional tables. Illustrated here are tables for the entities SUPPLIER and PART showing how they
Get Access