CPSC 044. Database Systems
This course provides an introduction to relational database management systems. Topics covered include data models (ER and relational model); data storage and access methods (files, indices); query languages (SQL, relational algebra, relational calculus, QBE); query evaluation; query optimization; transaction management; concurrency control; crash recovery; and some advanced topics (distributed databases, object relational databases). A project that involves implementing and testing components of a relational database management system is a large component of the course.
Group 2 course.
Prerequisite: CPSC 031 and CPSC 035
Natural science and engineering.
Lab work required.
Catalog chapter: Computer Science
Department website: https://www.swarthmore.edu/computer-science
Check the Spring 2021 Schedule of Courses
Check the Fall 2021 Schedule of Courses