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 Ramakrishnan & Gehrke before each class. The reading assignment is indicated in the first column. For example, for the Lectures on Conceptual Design Using the ER Model (Classes 3 and 4) you should read Chapter 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.
The first portion of this course will be a review of material you should have encountered in CSE 305 (or its equivalent). In general, I will asume that you are completely familiar with the material covered in Chapters 1-15 of the course text.
Class#/ Date Lecture# Topic
Chptr#
------ ---- -------- -----
1/1 8/27 1 Principles of Database Systems
2/3 8/29 2 The Relational Model
9/3 Labor Day
3/2 9/5 3 Conceptual Design Using the ER Model
4/2 9/10 3 cont.
5/4 9/12 4 Relational Algebra
9/17 Rosh Hashanah (no class)
9/19 Rosh Hashanah (no class)
6/5 9/24 5 SQL: The Query Language
9/26 Yom Kippur (no class)
7/5 10/1 5 cont.
8/3 10/3 6 SQL: DDL, ICs, Updates and Views
9/25 10/8 7 Object-Relational Database Systems
10/25 10/10 7 cont.
11/25 10/15 7 cont. Object-Oriented Database Systems
12/25 10/17 7 cont.
13/25 10/22 8 Internet Databases
10/24 Midterm Exam
14/22 10/29 8 cont.
15/22 10/31 9 Data Warehousing & OLAP
16/23 11/5 9 cont.
17/23 11/7 10 Parallel DBMS
18/21 11/12 10 cont.
19/21 11/14 11 Distributed Databases (background: Chapters 18-20)
11/19 Thanksgiving Recess
11/21 " "
20/21 11/26 11 cont.
21/18 11/28 12 Database Design
22/16 12/3 12 cont.
23/8 12/5 13 Database Tuning
24/16 12/10 13 cont.
25/15 12/12 14 Data Mining
12/19 Final Exam (5:00--7:30pm)