CPSC 437/537: Database Systems (Fall 2019)

Time: TTh, 9:00am - 10:15am
Location: WLH 119

Instructor: Avi Silberschatz (AKW 308, avi@yale.edu)
Office Hours: By appointment

TA: Jialu Zhang (AKW 210, jialu.zhang@yale.edu)
Office Hours: Thursday, 1 PM to 2 PM

TA: Yuyang Sang (AKW 304, yuyang.sang@yale.edu)
Office Hours: Wednesday, 1 PM to 2 PM

Textbook: Database System Concepts, Seventh Edition

Course description: An introduction to database systems. Data modeling. The relational model and the SQL query language. Relational database design, integrity constraints, functional dependencies, and normal forms. Implementation of databases: file structures, indexing, query processing, transactions, concurrency control, recovery systems, and security.