| Week | Topics | Reading | |
|---|---|---|---|
| 1 | An Introduction to Database Systems | 1,2 | |
| 1 | The four data models | 1,2 | |
| 2-3 | Relational Data Model | 6 | |
| 2-3 | Relational Algebra | notes | |
| 3-4 | SQL - A relational Database language | 7 | |
| 5 | Relational Calculus | 8 | |
| 5 | Exam 1 | 1-3, 6-9 | |
| 6 | Database Design | 3 | |
| 6-7 | ER Model | 3, 21 | |
| 8 | Spring break | -- | |
| 9-10 | Normalalization | 12-13 | |
| 10 | Exam 2 | 3, 12-13, 21 | |
| 11 | Transaction processing | 17 | |
| 11-12 | Concurrency | 18 | |
| 12-13 | Recovery and Security | 19-20 | |
| 13 | Distributed databases | 23 | |
| 14 | Object-oriented databases | 22 | |
| 15 | Future of databases | notes | |
| 15 | Review | everything |