Notes
Slide Show
Outline
1
Chapter 10 Database Management
2
Chapter 10 Objectives
3
Data and Information
  • How are data and information related?
4
Data and Information
  • What is a database?
5
Data and Information
  • What is data integrity?
6
Data and Information
  • What are the qualities of valuable information?
7
The Hierarchy of Data
  • What is a hierarchy?
8
The Hierarchy of Data
  • What is a field?
9
The Hierarchy of Data
  • What are common data types?
10
The Hierarchy of Data
  • What is a record?


11
The Hierarchy of Data
  • What is a data file?
12
Maintaining Data
  • What is file maintenance?
13
Maintaining Data
  • Why do you add records?
14
Maintaining Data
  • Why do you change records?
15
Maintaining Data
  • Why do you delete records?
16
Maintaining Data
  • What is validation?
17
Maintaining Data
  • What are the types of validity checks?
18
File Processing Versus Databases
  • What is a file processing system?
19
File Processing Versus Databases
  • What is the database approach?
20
File Processing Versus Databases
  • What are the strengths of the database approach?
21
File Processing Versus Databases
  • How do a database application and a file processing application differ in the way they store data?
22
Database Management Systems
  • What are popular database management systems (DBMSs)?
23
Database Management Systems
  • What is a data dictionary?
24
Database Management Systems
  • What is a query?
25
Database Management Systems
  • What is a query by example (QBE)?
26
Database Management Systems
  • What is a form?
27
Database Management Systems
  • What is a report generator?
28
Database Management Systems
  • What is data security?
29
Database Management Systems
  • What are backup and log?
30
Database Management Systems
  • What is a recovery utility?
31
Relational, Object-Oriented, and Multidimensional Databases
  • What is a data model?
32
Relational, Object-Oriented, and Multidimensional Databases
  • What is a relational database?
33
Relational, Object-Oriented, and Multidimensional Databases
  • What is a relationship?
34
Relational, Object-Oriented, and Multidimensional Databases
  • What is Structured Query Language (SQL)?
35
Relational, Object-Oriented, and Multidimensional Databases
  • What is an object-oriented database (OODB)?
36
Relational, Object-Oriented, and Multidimensional Databases
  • What are examples of applications appropriate for an
    object-oriented database?
37
Relational, Object-Oriented, and Multidimensional Databases
  • What is a multidimensional database?
38
Relational, Object-Oriented, and Multidimensional Databases
  • What is a data warehouse?
39
Web Databases
  • What is a Web database?
40
Web Databases
  • How might a search engine interact with a Web database?
41
Database Administration
  • What are guidelines for developing a database?
42
Database Administration
  • What is the role of the database analyst and administrator?
43
Summary of Database Management