Coronel PPT Ch01

Topics: Data management, Database management system, Database Pages: 35 (1962 words) Published: March 5, 2015
11e

Database Systems
Design, Implementation, and Management

Coronel | Morris

Chapter 1
Database Systems
©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Learning Objectives
 In this chapter, you will learn:
 The difference between data and information
 What a database is, the various types of databases, and
why they are valuable assets for decision making
 The importance of database design
 How modern databases evolved from file systems

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

2

Learning Objectives
 In this chapter, you will learn:
 About flaws in file system data management
 The main components of the database system
 The main functions of a database management system
(DBMS)

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

3

Data vs. Information
Data

 Raw facts
 Raw data - Not yet been
processed to reveal the
meaning
 Building blocks of information
 Data management

Information

 Produced by processing data
 Reveals the meaning of data
 Enables knowledge creation
 Should be accurate, relevant, and
timely to enable good decision
making

 Generation, storage, and
retrieval of data

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

4

Data vs. Information

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

5

Data vs. Information
 Search the web to compare wireless wearable devices
(smartwatches), their features and corresponding
prices.
 Make the distinction between data and information.
 Provide examples of what constitutes data and what
constitutes information as far as the results of your
research are concerned.

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

6

Database
 Shared, integrated computer structure that stores a
collection of:
 End-user data - Raw facts of interest to end user
 Metadata: Data about data, which the end-user data are
integrated and managed
 Describe data characteristics and relationships

 Database management system (DBMS)
 Collection of programs
 Manages the database structure
 Controls access to data stored in the database

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

7

Role of the DBMS
 Intermediary between the user and the database
 Enables data to be shared
 Presents the end user with an integrated view of the
data
 Receives and translates application requests into
operations required to fulfill the requests
 Hides database’s internal complexity from the
application programs and users

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

8

Figure 1.2 - The DBMS Manages the Interaction
between the End User and the Database

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

9

Advantages of the DBMS
• Better data integration and less data inconsistency
– Data inconsistency: Different versions of the same data
appear in different places








Increased end-user productivity
Improved:
Data sharing
Data security
Data access
Decision making
 Data quality: Promoting accuracy,...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Coronel
  • Ch01 Essay
  • ch01 ppt 2 Essay
  • CFFM8 PPT ch01 Essay
  • Ppt Essay
  • PPT Research Paper
  • Ppt Essay
  • BB107 PPT Microecon CH01 6 Essay

Become a StudyMode Member

Sign Up - It's Free