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