Relational Database Concepts

Catalog description

This course introduces students to the concepts, management issues, and advantages of relational database management systems. Topics covered in the class will include data definition, data manipulation, relational algebra, Structured Query Language (SQL), and Online Transaction Processing (OLTP) systems. Also, this class examines database design, normalization for OLTP systems, Codd’s rules for OLTP systems, data integrity, database system functions (journaling, forward recovery, and backward recovery), database security (authentication and authorization), and database administration. Other topics that students will explore in this course include distributed databases, Online Analytic Processing (OLAP) systems, data warehouses, and object-oriented databases.