Class slides will be posted soon after the class. You are highly encouraged to attend all classes.
Please note that the schedule may be subject to change depending how quickly or slowly we are able to move through lectures
Here is the zoom link for lectures
Lecture recordings can be found here
| Date | Slides | Book Sections | Assignments out | Assignments In |
|---|---|---|---|---|
| September 10 | Introduction to the Course | |||
| September 15 | Introduction to Databases | Chap. 1 | ||
| September 17 | The Relational Model | Chap. 2 | ||
| September 22 | Relational Algebra | Chap. 6.1 | Homework 1 | |
| September 24 | Entity-Relationship Model | Chap. 7.2 | ||
| September 29 | SQL 1 | Chap. 3 | ||
| October 1 | SQL 2 | Chap. 3 | ETL (On 10/2) | Homework 1 |
| October 6 | Constraints | Chap. 4.4 | Homework 2 | |
| October 8 | Normalization | Chap. 7 | ||
| October 13 | Functional Dependencies continued | Chap. 4.4 | Homework 3 | Homework 2 |
| October 15 | Storage and File Structure | Chap. 10 | ||
| October 20 | Storage and File Structure, B-Trees | Chap. 10 | Homework 3 | |
| October 22 | B-Trees continued, Hashing | Chap. 13 | ETL (On 10/25) | |
| October 27 | Query Processing Continued | Chapter 14 | Homework 4 | |
| October 29 | Quiz 1 | B+Tree | ||
| November 3 | No class - Election Day | |||
| November 5 | Transactions Continued | Chap. 15 | ||
| November 10 | Transactions | Chap. 15 | Homework 4 | |
| November 12 | Concurrency | Chap. 16 | Homework 5 | |
| November 17 | Recovery | Chap. 19 | B+Tree | |
| November 19 | Guest lecture | Concurrency and Recovery | Homework 5 | |
| November 24 | Quiz 2 | |||
| November 26 | Thanksgiving -- No Class | |||
| December 1 | Thanksgiving -- No Class | |||
| December 3 | Reading Period -- No Class | |||
| December 8 | Finals Period -- No Class | Concurrency and Recovery |