Links: [Course Home] [Course Info] [Course Schedule] [Resources] [WebCT]
| Week | Date | Topic | Readings | Assignments |
|---|---|---|---|---|
| 1 | M 1/26 | Course overview and introduction | Ch. 1, 2.1 | |
| W 1/28 | Relational data model intro | Ch. 2.2 | ||
| 2 | M 2/2 | SQL intro; E/R model intro | Ch. 2.3, 4.1 | |
| W 2/4 | E/R model, continued | Ch. 4.1-4.2 | ||
| 3 | M 2/9 | Relational algebra | Ch. 2.4 | |
| W 2/11 | Relational algebra and constraints | Ch. 2.4-2.5 | ||
| 4 | M 2/16 | University holiday; no class | ||
| W 2/18 | Constraints in E/R model | Ch. 4.3-4.4 | ||
| 5 | M 2/23 | E/R to relational mapping | Ch. 4.5-4.6 | Proj. 1 assigned |
| W 2/25 | E/R to relational mapping | |||
| 6 | M 3/2 | Introduction to SQL | Ch. 6.1-6.2 | |
| W 3/4 | Midterm 1 review | Proj. 1 due (5 PM) | ||
| 7 | M 3/9 | MIDTERM 1 | ||
| W 3/11 | SQL, continued | Ch. 6.3 | ||
| 8 | M 3/16 | SQL, continued | Ch. 6.4-6.5 | Proj. 2 assigned |
| W 3/18 | [Updated] Creating and modifying data; transactions | Ch. 6.5-6.6 | ||
| 9 | M 3/23 | [Updated] Views and constraints | Ch. 8.1, 7.1-7.3 | Lab 2 |
| W 3/25 | [Updated] Triggers; SQL in server environments | Ch. 7.5, 9.1-9.2 | ||
| 10 | M 3/30 | PL/SQL | Ch. 9.4 (skim); see online resources | Lab 3 |
| W 4/1 | PHP | Ch. 9.7 | Proj. 2 due Proj. 3 assigned Lab 4 assigned | |
| 11 | M 4/6 | Midterm 2 review | ||
| W 4/8 | MIDTERM 2 (solutions) | |||
| 12 | Spring Break; no class 4/13-4/17 | |||
| 13 | M 4/20 | Review and practice | ||
| W 4/22 | Functional dependencies | Ch. 3.1-3.2.4 | Proj. 3 progress report due (11:59 PM) | |
| 14 | M 4/27 | Normalization | Ch. 3.3, 3.4.1, 3.4.4, 3.5 | |
| W 4/29 | Normalization summary; extra credit SQL quiz | |||
| 15 | M 5/4 | Semi-structured data and XML | Ch. 11.1-11.3 | |
| W 5/6 | XML schemas; XPath | Ch. 11.4-12.1 | ||
| 16 | M 5/11 | XPath and XQuery | Ch. 12.1-12.2 | Proj. 3 due Tues. at 11:59 PM |
| W 5/13 | Final exam review | |||
| 17 | M 5/18 | FINAL EXAM, 11:00 AM-12:50 PM | ||