="http://www.w3.org/TR/REC-html40">
td> Oct 14 | No Class |
Fall Study Break |
|
| 12 | Oct 16 | Spill-over material and some review |
| |
| Discussion | Oct 18 |
Exam Review |
|
|
| |
Oct 18 |
First Floor Dow Building |
Rooms assigned by last name |
First Exam at 7PM |
| 13 | Oct 21 |
Hash-based Indexing | Ch. 11 |
Homework 3 Out |
| 14 | Oct 23 |
Tree-Structured Indexing | Ch. 10, except 10.8.1 |
|
| Discussion | Oct 25 | Exam solutions |
| |
| 15 | Oct 28 | Sorting | Ch. 13 | |
| 16 | Oct 30 | Storage & Indexing (contd.) | Ch. 8
| |
| |
Oct 31 |
|
|
Homework 3 due at 11:55PM |
| Discussion | Nov 1 |
HW 3 Solutions |
|
|
| 17 | Nov 4 | Query Evaluation | Ch. 12,
Ch. 14 | Homework 4 Out |
| 18 | Nov 6 | Query Evaluation |
| |
| |
Nov 7 |
|
|
Project 3 due at 11:55PM |
| Discussion | Nov 8 | Canceled | | Project 4 Assigned |
| 19 | Nov 11 | Query Optimization | Ch. 15 |
|
| 20 | Nov 13 |
Transactions | Ch. 16,
except 16.6; Ch. 17, up to and including 17.4 | |
| |
Nov 14 |
|
|
Homework 4 due at 11:55PM |
| Discussion | Nov 15 | HW 4 Solutions and Project 4 intro |
|
|
| 21 | Nov 18 |
Transactions (contd.) | Ch. 18, except 18.6 and 18.8
|
Homework 5 Out |
| 22 | Nov 20 | Open Topics | |
|
| Discussion | Nov 22 |
Review of counting page accesses |
| |
| 23 |
Nov 25 |
Open Topics |
|
Project 4 due at 11:55PM |
| | Nov 27 |
No Lecture | Happy Thanksgiving! | |
| | Nov 29 |
No Discussion | Happy Thanksgiving! | |
| 25 | Dec 2 |
Normalization |
Ch. 19 until 19.3 |
Watch 24-RelDesignOverview, 25-FunctionalDependencies, 26-BCNF |
| 26 | Dec 4 |
Normalization (contd.) and Tuning |
Ch. 19 except 19.8, and Ch. 20.7-20.9 |
Watch 27-MVDs4NF, 35-NormalFormShortcomings |
| |
Dec 5 |
|
|
Homework 5 due at 11:55PM |
| Discussion | Dec 6 | HW 5 Solutions |
| |
| 27 | Dec 9 | Review | |
|
| | Dec 13 | Second Exam | | |