9781423901785_PPT_ch07

9781423901785_PPT_ch07 - Management Information Systems...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
Management Information Systems, Sixth Edition Chapter 7: Databases and Data Warehouses
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Management Information Systems, Sixth Edition 2 Objectives Explain the difference between traditional file organization and the database approach to managing digital data Explain how relational and object-oriented database management systems are used to construct databases, populate them with data, and manipulate the data to produce information Enumerate the most important features and operations of a relational database, the most popular database model
Background image of page 2
Management Information Systems, Sixth Edition 3 Objectives (continued) Understand how data modeling and design creates a conceptual blueprint of a database Discuss how databases are used on the Web List the operations involved in transferring data from transactional databases to data warehouses
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Management Information Systems, Sixth Edition 4 Managing Digital Data Businesses collect and dissect data for many purposes Data can be stored in database format Easy access and manipulation Databases have had a profound impact on business An information industry has been created Database technology integrated with the Internet has contributed to commerce significantly
Background image of page 4
Management Information Systems, Sixth Edition 5 The Traditional File Approach Traditional file approach : no mechanism for tagging, retrieving, or manipulating data Database approach : provides powerful mechanism for managing and manipulating data Traditional approach is inconvenient: Program-data dependency High data redundancy Low data integrity Data redundancy : duplication of data Data integrity : accuracy of data
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Management Information Systems, Sixth Edition 6 The Traditional File Approach (continued)
Background image of page 6
Management Information Systems, Sixth Edition 7 The Database Approach Database approach : data organized as entities Entity : an object about which an organization chooses to collect data, such as: People Events Products Character : smallest piece of data A single letter or a digit Field : single piece of information about entity
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Management Information Systems, Sixth Edition 8 The Database Approach (continued) Record : collection of related fields File : collection of related records Database fields can hold images, sounds, video clips, etc. Field name allows easy access to the data Database management system (DBMS) : program used to: Build databases Populate a database with data Manipulate data in a database
Background image of page 8
Management Information Systems, Sixth Edition 9
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Management Information Systems, Sixth Edition 10
Background image of page 10
Management Information Systems, Sixth Edition 11 The Database Approach (continued) Query : a message to the database requesting
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/14/2011 for the course MGSC 290 taught by Professor Johnston during the Fall '09 term at South Carolina.

Page1 / 40

9781423901785_PPT_ch07 - Management Information Systems...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online