Written Assignments

WA1, due 9/25 11:59pm
E-R Model / Relational Model / Relational Algebra

WA2, due 10/20 11:59pm
SQL / Normalization / Functional Dependencies

WA3, due 11/17 11:59pm
Disks / Storage / Index / Hashing / Query Processing

WA4, due 12/8 11:59pm (gradescope)
Concurrency Control / Recovery / Logging (NEW)

Programming Assignments

PA1, due E-R diagram 10/6, Full Project 11/3
Build a database system enabled application

PA2, due 12/2 11:59pm (gradescope)
Query Optimization & Row-stores vs. Column-stores

PA3, due 12/18 11:59pm (gradescope)
Key-value stores (NEW)