The following schedule of class lectures is subject to change. I will let you know about any changes as far in advance as possible. You are responsible for reading the appropriate chapter in the course textbook before each class. The reading assignment is indicated in the first column. For example, for the lectures on Principles of Database Systems (Classes 1-3) you should read Chapters 1 and 2 of the text. The lectures are ordered in such a way as to expose you to material you will need for the programming project (e.g. relational algebra, SQL) as early in the course as possible.
Class#/ Date Lecture# Topic
Chptr#
------ ---- -------- -----
1/1 1/26 1 Principles of Database Systems
2/1 1/28 1 cont.
3/2 2/2 2 Relational Databases & Transaction Processing
4/2 2/4 2 cont.
5/3 2/9 3 The Relational Model & SQL DDL
6/3 2/11 3 cont.
7/3 2/16 3 cont.
8/4 2/18 4 Conceptual Design Using the ER Model
9/4 2/23 4 cont.
10/4 2/25 4 cont.
11/5 3/2 5 Relational Algebra & SQL
12/5 3/4 5 cont.
13/5 3/9 5 cont.
14/5 3/11 5 cont.
3/16 Midterm Exam
15/6 3/18 6 Schema Refinement and Normalization
16/6 3/23 6 cont.
17/6 3/25 6 cont.
18/6 3/30 6 cont.
19/6 4/1 6 cont.
4/6 Spring Recess
4/8 Spring Recess
20/8 4/13 8 Using SQL in an Application
21/8 4/15 8 cont.
22/9 4/20 9 File Organization and Indexing
23/9 4/22 9 cont.
24/10 4/27 10 Implementation of Relational Operations
25/10 4/29 10 cont.
26/11 5/4 11 Relational Query Optimization
27/11 5/6 11 cont.
5/7 Demo Day (Rm 2114, Computer Science Bldg)
5/13 Final Exam (5:00--7:30pm)