CSE 412/598
|
Date |
Topic |
Out |
In |
|
|
8/23 |
Introduction |
|
|
EN1, EN2, D1.1 |
|
8/25 |
DB Design Overview |
|
|
EN12.2 |
|
8/30 |
Project Overview |
Phase 1 |
|
|
|
9/1 |
ER Model |
|
|
EN3, D1.2 |
|
9/6 |
ER Model |
|
|
|
|
9/8 |
Relational Intro, ER-Rel Map |
|
|
EN5, EN7.1, D1.3 |
|
9/13 |
|
|
|
D7; MS Access Tutorial |
|
9/15 |
Relational Algebra |
|
Phase 1 int |
EN6.1-6.5, D2; WinRDBI tutorial |
|
9/20 |
Relational Algebra |
HW1; P1 int |
|
|
|
9/22 |
Query Optimization |
|
|
EN15.7, D2.5 |
|
9/27 |
Relational Design |
Phase 2 |
Phase 1 |
EN10, EN11.1-11.2 |
|
9/29 |
Phase 1
presentations |
|
|
|
|
10/4 |
Relational Design |
Phase 1 |
HW1 |
|
|
10/6 |
MIDTERM |
|
|
|
|
10/11 |
Relational Design |
|
|
|
|
10/13 |
Relational Design |
HW1 |
|
|
|
10/18 |
Relational Design |
Midterm |
Phase 2 int |
|
|
10/20 |
TRC/DRC |
P2int |
|
EN6.6-6.7,D3, D4 |
|
10/25 |
TRC/DRC |
|
|
|
|
10/27 |
TRC/DRC; SQL |
HW2; Phase 3 |
Phase 2 |
|
|
11/1 |
SQL |
|
|
EN8, EN9.1-9.2, D5 |
|
11/3 |
SQL |
HW3; Phase2 |
|
|
|
11/8 |
SQL; Oracle |
|
|
|
|
11/10 |
SQL |
|
|
|
|
11/15 |
Security and Authoriz. |
|
HW2 |
EN23.1-23.4,EN17 |
|
11/17 |
Recovery |
|
|
EN18 |
|
11/22 |
Concurrency |
HW2 |
HW3 |
EN19 |
|
11/29 |
Transactions, Recovery |
HW3 |
Phase 3 |
|
|
12/1 |
Spare .. |
|
|
|
|
12/6 |
Exam Review |
Phase 3 |
|
|
|
|
|
|
|
|
|
12/8 |
FINAL EXAM |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|