week |
date |
topics (tentative) |
due dates |
related info |
1 |
Sept. 4 |
Introduction (Ch.1), E-R Model (Ch.2)) |
|
|
2 |
Sept. 11 |
Relational Model (Ch.3) |
|
hw1 out |
3 |
Sept. 18 |
SQL (Ch.4) |
hw1 due |
|
4 |
Sept. 25 |
QBE, Quel (Ch.5) |
|
hw2 out |
5 |
Oct. 2 |
Integrity Constraints (Ch.6), Relational DB Design (Ch.7) |
hw2 due |
hw3 out |
6 |
Oct. 9 |
Relational DB design (Ch.7) |
|
|
7 |
Oct. 16 |
Storage (Ch.10) |
hw3 due |
hw4 out |
8 |
Oct. 23 |
File Structure (Ch.10), Indexing and Hashing (Ch.11), Review |
hw4 due |
project1 starts |
9 |
Oct. 30 |
MIDTERM, Query Processing (Ch.12) |
Midterm |
hw5 out, opt. project2 starts |
10 |
Nov. 6 |
Transactions (Ch.13), Concurrency Control (Ch.14) |
hw5 due |
presentations |
11 |
Nov. 13 |
Concurrency Control (Ch.14), Recovery (Ch.15) |
|
hw6 out, presentations |
12 |
Nov. 20 |
Object Relational DB (Ch.9), Parallel DB (Ch.17)) |
hw6 due |
presentations |
13 |
Nov. 27 |
No class |
|
|
14 |
Dec. 4 |
Distributed DB (Ch.18), Multimedia DB, Queries by Content |
|
presentations |
15 |
Dec. 11 |
Data Mining and Rule Discovery, Review |
project1, opt. project2 due |
presentations |
16 |
Dec. 18 |
Final Exam |
|
|