| Week | Dates |
Lecture Topics |
Textbook |
Due* | Feedback |
| 1 |
1/20-1/23 |
Introductions |
1 |
| |
| 2 |
1/26-1/30 |
Relational Model |
3 |
HW 0 | |
| 3 |
2/2-2/6 |
SQL Queries |
4 |
| |
| 4 |
2/9-2/13
| ER Diagrams - Overview, Syntax |
5 |
HW 1 |
|
| 5 |
2/16-2/20 |
ER Diagrams - Data Modeling |
6 |
|
HW 1 |
| 6 |
2/23-2/27 |
Normalization |
7 |
HW 2 |
|
| 7 |
3/2-3/6 |
Physical DB Design-1 |
8 |
|
HW 2 |
| 8 |
3/9-3/13 |
Midterm Exam |
|
| |
| 9 |
3/16-3/20 |
Spring Break |
|
| |
| 10 |
3/23-3/27 |
Physical DB Design-2 |
8 |
| |
| 11 |
3/30-4/3 |
Advanced Query Formulation with SQL |
9 |
|
|
| 12 |
4/6-4/10
| Transaction Management Data Warhouses |
15 16 |
HW 3 |
|
| 13 |
4/13-4/17
| Data Warehouses Transaction Management |
16 15 |
|
HW 3 |
| 14 |
4/20-4/24 |
Object DBMS |
18 |
HW 4 |
|
| 15 |
4/27-5/1 |
Client-Server Processing, Parallel Database Processing, and Distributed Databases |
17 |
|
HW 4 |
| 16 |
5/4-5/8 |
Trends In Spatial DBMS and Practice Exam |
|
|
|
| 17 |
5/15 |
Exam, 1:30PM-3:30PM |
|
|
|