-->
| Week | Date | chapter.section | Lecture Topic | HW/Projects | |
|---|---|---|---|---|---|
| 1 | 9/28 | 1.1, 1.2, 1.3, 1.4, 1.5, 1.11 | Introduction, Relational Model | ||
|
2.1, 2.2, 2.3, 5.2 |
Relational Algebra. Domain Relational Calculus. |
Due Monday 10/5 * | |||
| 2 |
10/5 |
Ch 3 all, |
SQL |
||
| Ch 4 till 4.6 (excluded) | Constraints & Triggers: |
Project1 Assigned Due October 19 |
|||
| 3 | 10/12 | 5.3 |
QBE
|
HW 2 due* | |
| 11.1, 11.2, 11.3, 11.5, 11.6, 11.77 |
Disks and Files
|
||||
| 4 |
10/19 |
12.1-3, 12.6-8, 12.10 | Indexing (B+tree ) |
Proj 1 due** | |
| Extendible hashing, Query Processing |
Project 2 Assigned | ||||
| 5 |
10/26 |
13.1-13.6, 14.1, 14.3.1, 14.3.3 | Query Processing
and Optimization |
Hw 3 due* | |
| 6 |
11/02 |
Midterm | |||
|
6.1-6.9
|
ER Model & ER to RDB | ||||
| 7 | 11/09 |
7.1-7.3
|
DB DesignFDs, 3NF, BCNF | ||
| 11/11 |
Veterans Day | Holiday | |||
| 8 | 11/16 | Section
7.4, 7.5, and Section 15 (omit 15.2.2) |
Schema Design
with FDs/ER Introduction to Transaction |
Proj 2 due |
|
| 9 | 11/23 |
15, 16.1,16.1.1, 16.1.2, 16.1.3, 16.6,17.1, 17.4 | Locking & Recovery | Hw 4 due*: | |
| 10 | 11/30 | 16.2 (Timestamp-based Protocols) 22.4.1 (Two-Phase Commit) | Distributed transactions | Proj 3 due | |
| 11 | 12/7 |
Final Exam (8-11am) |