DATABASE SYSTEMS (6 SCU)

Learning Outcomes:

Upon successful completion of this course, students are expected to be able to: Identify, define and analyze requirements and anomalies in relational database design; Use conceptual modeling mechanisms to design a database system; Formulate queries for specific users’ information needs; Use SQL as a data definition and data manipulation language; Apply transaction processing and concurrency in multi-user database systems to obtain accurate results.

Topics:

This course is designed to teach students the fundamental concepts underlying database system design, including not only the design of applications using databases, but also covering the fundamental implementation techniques used in database systems. It introduces students to the relational model of databases along with its mathematical background, the application of relational database system and the system-level implementation, including File Organizations and Indexes, query processing, and transaction management
Pre-requisite: None