The assignments will be graded on completion basis, that is, you will receive full credit as long as you submit them on time and receive a grade above 70%. You will submit your written assignments through Gradescope. No late days can be used on written assignments.
Title & Description | Release Date | Due Date | Material |
WA1 | 9/10 | 9/19 | ER Modeling + Relational Model |
WA2 | 9/20 | 9/27 | Relational Algebra |
WA3 | 9/28 | 10/4 | Functional Dependencies & Normalization |
WA4 | 10/5 | 10/11 | SQL |
WA5 | 10/12 | 10/18 | Storage Layer & B+ Tree |
WA5b | 11/10 | 11/17 | External Sorting, Hash Index and LSM (Bonus) |
WA6 | 11/16 | 11/23 | Query Optimization & Processing |
NEW: WA7 | 11/30 | 12/06 | Locking & Logging |