This schedule is subject to change so check it frequently. In particular, check for changes to due dates and guest lectures.
Note: in general, the pdf files are smaller (in bytes) than the ppt files.
WK |
Lec# |
Class/Date |
Topic |
Book Chapter |
Events |
Lecture Notes |
1 |
1 |
T 8/26 |
Introduction |
1 |
ppt
pdf |
|
2 |
Th 8/28 |
The Relational Model |
3 |
ppt
pdf |
||
2 |
3 |
T 9/2 |
Introduction to the ER Model Storing Data: Disks and Files |
2 (skim) 9 |
ppt pdf | |
4 |
Th 9/4 |
Relational Algebra |
4 | Homework 0 Due |
ppt pdf | |
3 |
5 |
T 9/9 |
File Organization and Indexing |
8 |
ppt pdf | |
6 |
Th 9/11 |
Relational Calculus |
4 |
|
ppt pdf | |
4 |
7 |
T 9/16 |
SQL I |
5 |
|
ppt pdf |
8 |
Th 9/18 |
Query Evaluation 1: Sorting & Joining |
12, 13, 14 |
Homework 1 Due | ppt pdf | |
5 |
9 |
T 9/23 |
Query Evaluation 2: Optimizing Queries |
12, 13, 14 |
ppt pdf | |
10 |
Th 9/25 |
SQL 2 |
5 |
ppt pdf |
||
6 |
11 |
T 9/30 |
The ER Model | 2 |
ppt pdf |
|
12 |
Th 10/2 |
ER -> Relational Mappings | 2, 3 |
ppt pdf |
||
Su 10/5 |
Homework 2 Due | |||||
7 |
13 |
T 10/7 |
Functional Dependencies and
Normalization |
19 | |
ppt pdf |
14 |
Th 10/9 |
FDs and Normalization (cont.) Midterm Review |
19 |
ppt pdf ppt pdf |
||
8 |
15 |
T 10/14 |
Internet Applications | 7 |
Midterm Exam 6-8pm |
ppt pdf |
16 |
Th 10/16 |
Database Applications | 6 |
ppt pdf |
||
9 |
17 |
T 10/21 |
Tree-Structured Indexes | 10 |
ppt pdf |
|
18 |
Th 10/23 |
Hash-Based Indexes | 11 |
ppt pdf |
||
10 |
19 |
T 10/28 |
Introduction to Transactions |
16 |
ppt pdf |
|
20 |
Th 10/30 |
Concurrency Control | 17 |
ppt pdf |
||
Su 11/2 |
Homework 3 Due |
|||||
11 |
21 |
T 11/4 |
Logging and Recovery |
18 |
ppt pdf |
|
22 |
Th 11/6 |
Concurrency Control (cont.) | 17 |
ppt pdf |
||
12 |
T 11/11 |
Veterans' Day Holiday |
||||
23 |
Th 11/13 |
Guest Lecture: Data Mining |
26 |
ppt pdf | ||
13 |
24 |
T 11/18 |
Concurrency Control (cont) |
17 |
Homework 4 Due |
ppt pdf |
25 |
Th 11/20 |
Query Optimization - Another Try |
15 |
ppt pdf | ||
14 |
26 |
T 11/25 |
Physical Database Design and
Tuning |
20 |
ppt pdf | |
Th 11/27 |
Thanksgiving Holiday |
|||||
15 |
27 |
T 12/2 |
Guest Lecture: Data Management at
E-Trade |
NA |
ppt pdf | |
28 |
Th 12/4 |
Class Wrap-Up |
ppt pdf | |||
Mo 12/8 |
Homework 5 Due | |||||
Tu 12/9 |
Final Exam Review - 306 Soda |
1pm - 3pm |
|
|||
Fr 12/12 | Final Exam - 4 LeConte |
5pm - 8pm | |