|
|
|
||
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 # |
Date |
Topic |
Reading |
Assignments Etc |
|
|
1 |
Sept 3 |
Introduction |
Ch.1 |
|
|
|
Discussion |
Sept 5 |
Java Tutorial |
|
|
|
|
2 |
Sept 8 |
ER Model |
Ch.2 |
|
|
|
3 |
Sept 10 |
Relational Model |
Ch. 3 |
Homework 1 Out |
|
|
Discussion |
Sept 12 |
Project 1 Intro |
Project 1 Assigned; Group Registration due |
|
|
|
4 |
Sept 15 |
ER to Relational |
Ch. 3 |
|
|
|
5 |
Sept 17 |
Relational Algebra |
Ch. 4 |
|
|
|
|
Sept 18 |
|
|
Homework 1 due at 11:55PM |
|
|
Discussion |
Sept 19 |
HW 1 Soln; Project 1 issues |
|
|
|
|
6 |
Sept 22 |
Relational Algebra(contd.) + Relational Calculus |
Ch. 4 |
Homework 2 Out |
|
|
7 |
Sept 24 |
SQL |
Ch. 5 |
|
|
|
|
Sept 25 |
|
|
Project 1 due at 11:55PM |
|
|
Discussion |
Sept 26 |
JDBC and Project 2 discussion |
|
Project 2 Assigned |
|
|
8 |
Sept 29 |
SQL (contd.) and Triggers |
Ch. 5 |
|
|
|
9 |
Oct 1 |
Database Application Pogramming |
Ch 6, except 6.4 and 6.5 |
|
|
|
|
Oct 2 |
|
|
Homework 2 due at 11:55PM |
|
|
Discussion |
Oct 3 |
HW 2 solutions, Open topics |
Read SQL Handout |
|
|
|
10 |
Oct 6 |
Normalization and Tuning |
Ch. 19 except 19.8, and Ch. 20.7-20.9 |
|
|
|
11 |
Oct 8 |
Wrap up for First Half |
|
|
|
|
|
Oct 9 |
|
|
Project 2 due at 11:55PM |
|
|
Discussion |
Oct 10 |
Exam Review |
|
|
|
|
|
Oct 13 |
No Class |
Fall Study Break |
|
|
|
13 |
Oct 15 |
Disks and Files |
Ch. 9, except 9.2 |
|
|
|
Discussion |
Oct 17 |
Postgres Overview |
|
Project 3 Assigned |
|
|
|
Oct 20 |
First Exam |
|
|
|
|
14 |
Oct 22 |
Storage & Indexing |
Ch. 8 |
Homework 3 Out |
|
|
Discussion |
Oct 24 |
Exam solutions |
|
|
|
|
15 |
Oct 27 |
Tree-Structured Indexing |
Ch. 10, except 10.8.1 |
|
|
|
16 |
Oct 29 |
Hash-based Indexing |
Ch. 11 |
|
|
|
|
Oct 30 |
|
|
Homework 3 due at 11:55PM |
|
|
Discussion |
Oct. 31 |
HW 3 Solutions, Open topics |
|
|
|
|
17 |
Nov 3 |
Sorting |
Ch. 13 |
|
|
|
18 |
Nov 5 |
Storage & Indexing (contd.) |
Ch. 8 |
Homework 4 Out |
|
|
|
Nov 6 |
|
|
Project 3 due at 11:55PM |
|
|
Discussion |
Nov 7 |
Project 4 intro and page counting |
|
Project 4 Assigned |
|
|
19 |
Nov 10 |
Query Evaluation |
Ch. 12, Ch. 14 |
|
|
|
20 |
Nov 12 |
Query Evaluation |
|
|
|
|
|
Nov 13 |
|
|
Homework 4 due at 11:55PM |
|
|
Discussion |
Nov 14 |
HW 4 Solutions, open topics |
|
|
|
|
21 |
Nov 17 |
Query Optimization |
Ch. 15 |
|
|
|
22 |
Nov 19 |
Transactions |
Ch. 16, except 16.6; Ch. 17, up to and including 17.4 |
|
|
|
Discussion |
Nov 21 |
Open topics |
|
Homework 5 out |
|
|
23 |
Nov 24 |
Transactions (contd.) |
Ch. 18, except 18.6 and 18.8 |
|
|
|
24 |
Nov 26 |
Transactions (contd.) |
|
|
|
|
Discussion |
Nov 28 |
No class |
Happy thanksgiving! |
|
|
|
25 |
Dec 1 |
Open Topics |
|
|
|
|
26 |
Dec 3 |
Open Topics |
|
|
|
|
|
Dec. 4 |
|
|
HW5 and P5 due at 11:55PM. |
|
|
Discussion |
Dec 5 |
HW 5 Solutions |
|
|
|
|
27 |
Dec 8 |
Open Topics |
|
|
|
|
28 |
Dec 10 |
Review |
|
|
|
|
|
Dec 12 |
Second Exam |
|
|
|