CS 5430 - Principles of Database Management Systems

The fundamentals of database design and usage are covered, focusing on the relational data model. Topics include basic DB and DBMS concepts, logical design (ER modelling, normalization), physical storage concepts, relational algebra, SQL query language, PL/SQL and embedded SQL. A relational DBMS is used for lab assignments. Other topics may include query optimisation, transaction processing, concurrency, security, forms/reports, object-relational data model, and an overview of advanced DB topics. A student may not receive credit for both CS 4430 and CS 5430.

Prerequisites & Corequisites: Prerequisite: CS 3310.

Credits: 3 hours