Database Management Systems
A database management system (DBMS) provides a environment with which to interact with a database that integrates data while minimizing pitfalls such as data redundancy. In addition, a DBMS maintains control of the underlying data, which ensures its security, supports backups and recovery, and maximizing concurrency. This module focuses on relational DBMSs as the perennial approach to managing data effectively in organizations.
Learning Objectives
- Indicate the records and fields of a simple linear file
- List the four fundamental data operations
- Compare and contrast sequential and direct access for data retrieval
- List the problems addressed by a database management system (DBMS)
- Describe the historical approaches for the design of a DBMS
How to Complete this Lesson
Complete the following learning activities: (2 hours total)
- Read Fundamentals of Database Management Systems Chapter 3: The Database Management System Concept (60 minutes)
- Attend the class meeting (60 minutes)
Due
As a reminder, the following is due this lesson:
Resources
- Questions for DBMS concepts (90 minutes)