course summary      course structure      schedule/readings      miscellaneous     

Schedule/Reading List

Lecture notes for the semester will be posted before the lecture date, but we will try to post material as far in advance as possible. Please print a copy of the notes if you need it during class. But do expect a few last-minute updates. The final version that you are responsible for will be online a day or so after class. Solutions to odd-numbered exercises in the book can be found at the dbbook website. This page is our current best idea of how the entire semester will proceed. However, information on this page is likely to change during the semester -- please check the latest version before preparing for class.

Lecture # Topic Reading Assignments
1 Welcome and Introduction Ch. 1
Discussion Java Tutorial
2 ER Model Ch. 2
3 Relational Model Ch. 3 Homework 1 Out. Project 1 Out.
Discussion Project 1 Intro
4 ER to Relational Ch. 3
5 Relational Algebra Ch. 4 Homework 1 due at 11:55PM
Discussion HW 1 Soln; Project 1 issues
6 Relational Algebra(contd.) + Relational Calculus Ch. 4 Homework 2 Out
7 SQL Ch. 5 Project 1 due at 11:55PM
Discussion JDBC and Project 2 discussion Project 2 Assigned
8 SQL (contd.) and Triggers Ch. 5
9 Database Application Pogramming Ch. 6, except 6.4 and 6.5 Homework 2 due at 11:55PM
Discussion HW 2 solutions, Open topics Read SQL Handout
10 Normalization Ch. 19 except 19.8, and Ch. 20.7-20.9
11 Wrap up for First Half Project 2 due at 11:55PM
Discussion Exam Review
12 Disks and Files Ch. 9, except 9.2
First Exam (7-9pm, location TBA)
Discussion Postgres Overview
13 Storage & Indexing Ch. 8
14 Storage & Indexing (contd)
Discussion Exam solutions
No Class
No Class
No Class Homework 3 Out (on March 9)
15 Tree-structured Indexing Ch. 10 except 10.8.1
16 Hash-based Indexing Ch. 11
Discussion Problems on indexing Project 3 assigned
17 Query Evaluation Ch. 12 and 14
18 Sorting Ch. 13 Homework 3 due on March 19 at 11:55PM
Discussion Homework 3 solutions
19 Query evaluation Ch. 12 Ch. 14 Homework 4 assigned
20 Query Evaluation Ch. 12 Ch. 14
Discussion Query evaluation review
21 Query Optimization Ch. 15 Project 3 due on March 30th at 11:55pm. Project 4 out on March 31.
22 Transactions Ch. 16, except 16.6; Ch. 17, up to and including 17.4 Homework 4 due on April 2 at 11:55pm.
Discussion Project 4 intro and page counting, Homework 4 solutions
23 Transactions (contd.) Ch. 18, except 18.6 and 18.8 Homework 5 assigned
24 Transactions (contd.)
Discussion Open Topics
25 Open Topics Homework 5 due at 11:55pm
26 Review
Discussion Homework 5 solutions, Review Project 4 due at 11:55pm
TBA
Second Exam (10:30am-12:30pm, locatoin TBA)
Date
Jan 8
Jan 9
Jan 13
Jan 15
Jan 16
Jan 20
Jan 22
Jan 23
Jan 27
Jan 29
Jan 30
Feb 3
Feb 5
Feb 6
Feb 10
Feb 12
Feb 13
Feb 17
Feb 19
Feb 20
Feb 24
Feb 26
Feb 27
March 3
March 5
March 6
March 10
March 12
March 13
March 17
March 19
March 20
March 24
March 26
March 27
March 31
April 2
April 3
April 7
April 9
April 10
April 14
April 16
April 17
April 21
April 27