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