Chapter 10 Database Management

Chapter 10 Objectives

Data and Information
How are data and information related?

Data and Information
What is a database?

Data and Information
What is data integrity?

Data and Information
What are the qualities of valuable information?

The Hierarchy of Data
What is a hierarchy?

The Hierarchy of Data
What is a field?

The Hierarchy of Data
What are common data types?

The Hierarchy of Data
What is a record?

The Hierarchy of Data
What is a data file?

Maintaining Data
What is file maintenance?

Maintaining Data
Why do you add records?

Maintaining Data
Why do you change records?

Maintaining Data
Why do you delete records?

Maintaining Data
What is validation?

Maintaining Data
What are the types of validity checks?

File Processing Versus Databases
What is a file processing system?

File Processing Versus Databases
What is the database approach?

File Processing Versus Databases
What are the strengths of the database approach?

File Processing Versus Databases
How do a database application and a file processing application differ in the way they store data?

Database Management Systems
What are popular database management systems (DBMSs)?

Database Management Systems
What is a data dictionary?

Database Management Systems
What is a query?

Database Management Systems
What is a query by example (QBE)?

Database Management Systems
What is a form?

Database Management Systems
What is a report generator?

Database Management Systems
What is data security?

Database Management Systems
What are backup and log?

Database Management Systems
What is a recovery utility?

Relational, Object-Oriented, and Multidimensional Databases
What is a data model?

Relational, Object-Oriented, and Multidimensional Databases
What is a relational database?

Relational, Object-Oriented, and Multidimensional Databases
What is a relationship?

Relational, Object-Oriented, and Multidimensional Databases
What is Structured Query Language (SQL)?

Relational, Object-Oriented, and Multidimensional Databases
What is an object-oriented database (OODB)?

Relational, Object-Oriented, and Multidimensional Databases
What are examples of applications appropriate for an
object-oriented database?

Relational, Object-Oriented, and Multidimensional Databases
What is a multidimensional database?

Relational, Object-Oriented, and Multidimensional Databases
What is a data warehouse?

Web Databases
What is a Web database?

Web Databases
How might a search engine interact with a Web database?

Database Administration
What are guidelines for developing a database?

Database Administration
What is the role of the database analyst and administrator?

Summary of Database Management