| Date |
Topic |
Readings
|
HW,
Project
deliverables
|
| Tu 1/18 |
Introduction to databases |
1 |
|
| Th 1/20 |
ODL |
2.1 |
HW1 out |
| Tu 1/25 |
Entity Relationship diagrams |
2.2 |
|
| Th 1/27 |
Design Principles |
2.3,2.4 |
Project groups formed |
| Tu 2/1 |
Modeling constraints |
2.5,2.6 |
|
| Th 2/3 |
The relational model, Intro to MS Access |
3.1, Notes |
Preliminary proposal |
| Tu 2/8 |
From ODL and ER to Relational Designs |
3.2-3.4 |
HW 1 due, HW2 out; |
| Th 2/10 |
Logic; Proofs |
Notes |
|
| Tu 2/15 |
Functional Dependencies |
3.5-3.6.2, Notes |
|
| Th 2/17 |
Decomposition |
3.7-3.7.4,3.7.7 |
E/R design due |
| Tu 2/22 |
Relational Algebra; SQL |
4.1,4.6,5.1-5.4 |
HW2 due, HW3 out; |
| Th 2/24 |
SQL |
5.5-5.7 |
|
| Tu 2/29 |
|
5.8-5.9 |
|
| Th 3/2 |
More SQL - more Access |
Notes |
Formal specification
due |
| Tu 3/7 |
Midterm review |
|
HW3 due, HW4 out |
| Th 3/9 |
Midterm examination
(tentative) |
|
|
| Tu 3/21 |
More SQL |
|
|
| Th 3/23 |
SQL aggregation |
5.5 |
|
| Tu 3/28 |
SQL subqueries |
5.3 |
Sample end to end
application |
| Th 3/30 |
Database modification |
5.7 |
|
| Tu 4/4 |
SQL Views, NULLs and outerjoins |
5.8-5.9 |
|
| Th 4/6 |
Connecting Access to the Web |
Notes |
|
| Tu 4/11 |
Constraints in SQL |
6.1-6.5 |
HW4 due, HW5 out |
| Th 4/13 |
SQL3 Triggers |
6.6 |
|
| Tu 4/18 |
Embedded SQL |
7.1 |
|
| Th 4/20 |
SQL Transactions and environment |
7.2-7.3 |
|
| Tu 4/25 |
Class review |
|
Project final report
due |
| Th 4/27 |
Project demos |
|
HW5 due |
| Th 5/4 |
FINAL EXAMINATION
(in
class) |
|
|
