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