| Lecture | Date | Description | Chapters covered |
| Lecture1 | May 10, 2005 | The E/R Data Model | Ch 2 |
| Lecture 2 | May 17, 2005 | The Relational Data Model
Relational Algebra |
Ch 3.1 - 3.3
Ch 5.2 |
| Lecture 3 | May 24, 2005 | Relational Algebra
Relational Calculus |
Ch 5.3 - 5.4 |
| Lecture 4 | May 31, 2005 | SQL | Ch 6.1 - 6.3 |
| Lecture 5 | June 7, 2005 | SQL, cont | Ch 6.4 - 6.7 |
| Lecture 6.1 | June 14, 2005 | SQL, cont, Constraints, assertions, triggers
Datalog |
Ch. 7
Ch. |
| Lecture 6.2 + 7 | June 14, June 21, 2005 | Datalog, Recursivity, cont | Ch.10 |
| Lecture 8 | July 5, 2005 | Embedded SQL | Ch 10 |
| Lecture 9 + 10 | July 12, 19, 2005 | Functional Dependencies, Normalization | Ch 3 |
| Lecture 11 | July 26, 2005 | Query execution | Ch 15 |
| Lecture 12
slide 1 slide 2 slide 3 slide 4 slide 5 slide 6 slide 7 slide 8 slide 9 slide 10 slide 11 slide 12 slide 13 slide 14 slide 15 slide 16 slide 17 slide 18 slide 19 slide 20 slide 21 slide 22 slide 23 slide 24 slide 25 slide 26 slide 27 |
August 2, 2005 | Transactions and Concurency |