Scott: Mon, Tue, Wed, Thu 1:30 - 3:00 and by appointment
Mitchell: Tue, Thur 12:00 - 2:00
| Week | Due | Topic | |
|---|---|---|---|
| 1: Jan 5 & 7 | Intro, DB Design, ER Model, Relational Algebra | ||
| 2: Jan 12 & 14 | Assignment 1, due 1/12 | Relational Algebra, SQL | |
| SQL Startup, due 1/12 | |||
| 3: Jan 19 & 21 | Assignment 2, due 1/19 | SQL (Aggregates, triggers, referential integrity) | |
| 4: Jan 26 & 28 | Scripting, Indexing, Performance | ||
| 5: Feb 2 & 4 | Assignment 3, due 2/2 | Scripting, Triggers | |
| 6: Feb 9 & 11 | Assignment 4, due 2/9 | Review/Normalization, MIDTERM, 2/11 | |
| Feb 11 | MIDTERM | MIDTERM | |
| 7: Feb 16 & 18 | Normalization | ||
| 8: Feb 23 | Assignment 5, due 2/23 | Normalization | |
| 8: Feb 25 | NO CLASS | NO CLASS | |
| 9: Mar 1 & 3 | Assignment 6, due 3/3 | JDBC, R-trees | |
| 10: Mar 8 | Assignment 7, due 3/8 | Review on 3/8, FINAL on 3/11 | |
| Mar 11 | FINAL | FINAL |