Principles of Database Systems

View/Open

Author

Metadata

Abstract

This course examines the underlying concepts and theory of database management systems. The course takes the learner through the foundations of database systems, focusing on basics such as the relational algebra and data model, schema normalization. The course focus is mainly on relational data models and relational query operations, together with SQL for data definitions and queries. The course offers a learner an introduction to the design and programming of database system Topics include : Data models, schemas, and Instances; Database language and Interfaces ; Data modeling using the Entity-relationship model ; Relational model concepts; Update operations; Relational algebra and the use of SQL in a programming environment.

The course has been designed in a way that will allow personalized learning. There are various topical activities at end of each topic for the learner to have a practical experience. The learner is encouraged to attempt each activity.