CSCI 360 | Principles of Database Systems

The management of data has been a central challenge throughout the history of computing. This course focuses on the core concepts and theory behind relational database systems. The relational data model is a framework designed to address longstanding issues in data management such as data independence, consistency, information loss, and performance. Topics include the relational model, relational algebra and SQL, relational database theory, schema design through normalization, query execution, hashing and indexing, and other factors that influence system performance. Students design schemas that capture an organization's information needs and write programs that integrate with a relational database. They also study and implement key data structures and algorithms that modern relational database systems rely on.