Database Management System
COURSE OVERVIEW
The course, Database Management Systems, provides an introduction to the management
of database systems. The course emphasizes the understanding of the fundamentals of
relational systems including data models, database architectures, and database
manipulations. In addition to technical concerns, more general issues are emphasized.
These include data independence, integrity, security, recovery, performance, database
design principles, and database administration.
COURSE OBJECTIVES
At the completion of this course, students should be able to do the following:
1. Understand the role of a database management system in an organization.
2. Understand basic database concepts, including the structure and operation of the
relational data model.
3. Construct simple and moderately advanced database queries using Structured
Query Language (SQL).
4. Understand and successfully apply logical database design principles, including E-R
diagrams and database normalization.
5. Design and implement a small database project using SQL..
6. Understand the concept of a database transaction and related database facilities,
including concurrency control, backup and recovery, and data object locking and
protocols.
7. Describe and discuss selected advanced database topics, such as distributed
database systems and the data warehouse.
8. Understand the role of the database administrator.