Course Websites

CS 411 - Database Systems

Last offered Fall 2024

Official Description

Examination of the logical organization of databases: the entity-relationship model; the hierarchical, network, and relational data models and their languages. Functional dependencies and normal forms. Design, implementation, and optimization of query languages; security and integrity; concurrency control, and distributed database systems. Course Information: 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.

Related Faculty


Database Systems: The Complete Book, 2nd Edition, by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom

Learning Goals

Analyze real-world data management scenarios and design appropriate data schemas (1), (2), (3), (4), (5), (6)
Formulate SQL queries to access a relational database system (1), (2), (5), (6)
Design and develop data management applications using relational database systems (1), (2), (3), (4), (5), (6)
Analyze and apply data indexing techniques for speeding up query processing (1), (2), (5), (6)
Analyze and apply query optimization techniques for optimizing query execution (1), (2), (5), (6)
Analyze and apply transaction processing techniques for executing transactions in relational database systems (1), (2), (5), (6)

Topic List

Data modeling principles and E-R Diagram Techniques
Relational Algebra
SQL Query Language
Data Storage and Indexing
Query Execution and Optimization
Concurrency Control & Failure recovery

Required, Elective, or Selected Elective

Selected Elective.

Database SystemsCSP72358PKG3 -    Abdussalam Alawini
Database SystemsCSP72358PKG31400 - 1515 R  ARR Illini Center Abdussalam Alawini
Database SystemsMC376348PKG3 -    Abdussalam Alawini
Database SystemsMC376348PKG31400 - 1515 R  ARR Illini Center Abdussalam Alawini
Database SystemsMC476349PKG4 -    Abdussalam Alawini
Database SystemsMC476349PKG41400 - 1515 R  ARR Illini Center Abdussalam Alawini
Database SystemsQG40086LEC31400 - 1520 M W  0027/1025 Campus Instructional Facility Abdussalam Alawini
Database SystemsQU30109LEC31400 - 1520 M W  0027/1025 Campus Instructional Facility Abdussalam Alawini