| Week | Date | Topic | Readings | Remarks |
|---|---|---|---|---|
| 1 | Mon Aug 20 | Course Organization | slides (pdf) | |
| 1 | Wed Aug 22 | The Worlds of Database Systems | Ch 1. | slides (pdf). Exercise 1 (pdf). |
| 2 | Mon Aug 27 | The Relational Model of Data | Ch 2. | Quiz 1 due. slides (pdf). Exercise 2 (pdf). |
| 2 | Wed Aug 29 | The Relational Model of Data | Ch 2. | slides (pdf). Exercise 3 (pdf). (html). |
| 3 | Mon Sep 3 | Labor Day Holiday | Quiz 2 due on Tue 11:30am | |
| 3 | Wed Sep 5 | Design Theory for Relational Databases | Ch 3. | slides (pdf). Exercise 4 (pdf). |
| 4 | Mon Sep 10 | Design Theory for Relational Databases | Ch 3. | slides (pdf). Exercise 5 (pdf). Soln(txt). Quiz 3 due. |
| 4 | Wed Sep 12 | Design Theory for Relational Databases | Ch 3. | slides (pdf). Exercise 6 (pdf). |
| 5 | Mon Sep 17 | High-Level Database Models | Ch 4. | Assignment 1 due at 5PM. slides (pdf). Exercise 7 (pdf). Quiz 4 due. |
| 5 | Wed Sep 19 | Algebraic and Logical Query Languages | Ch 5. | slides (pdf). Exercise 8 (pdf). |
| 6 | Mon Sep 24 | Algebraic and Logical Query Languages | Ch 5. | slides (pdf). Exercise 9 (pdf). Quiz 5 due. |
| 6 | Wed Sep 26 | The Database Language SQL | Ch 6. | slides (pdf). Exercise 10 (pdf). Assignment 2 due 2200. |
| 7 | Mon Oct 1 | Pre-Midterm Review | Quiz 6 due. mock-midterm(pdf). | |
| 7 | Wed Oct 3 | Midterm Exam | ||
| 8 | Mon Oct 8 | Post-Midterm Review | Quiz 7 due. | |
| 8 | Wed Oct 10 | The Database Language SQL | Ch 6. | slides (pdf). Exercise 11 (pdf). Project Proposals due 2355. |
| 9 | Mon Oct 15 | The Database Language SQL | Ch 6. | slides (pdf). Exercise 12 (pdf). data(zip). Quiz 8 due. |
| 9 | Wed Oct 17 | SQL in a Server Environment | Ch 9. | slides (pdf). Networking Intro(pdf). sqc (zip). |
| 10 | Mon Oct 22 | SQL in a Server Environment | Ch 9. | slides (pdf). Exercise 13 (pdf). odbc (zip). jdbc (zip). Quiz 9 due. |
| 10 | Wed Oct 24 | Constraints, Triggers, Views and Indexes | Ch 7., Ch 8 | slides (pdf). Exercise 14 (pdf). |
| 11 | Mon Oct 29 | Overview of Transaction Processing | Ch 18.{0-2}, Ch 17.1. | slides (pdf). Exercise 15 (pdf). Quiz 10 due. http://www.youtube.com/watch?v=AKJ9BMWIPiY http://www.youtube.com/watch?v=2RxXrMtj2bs |
| 11 | Wed Oct 31 | Overview of Transaction Processing | Ch 18.{0-2}, Ch 17.1. | slides (pdf). Exercise 16 (pdf). http://www.youtube.com/watch?v=zYzqKHhxDBM http://www.youtube.com/watch?v=NcwRurRueYA |
| 12 | Mon Nov 5 | Overview of Storage and Indexing | Ch 13.{0-2}, Ch 14.{0-2}. | slides (pdf). Exercise 17 (pdf). Quiz 11 due. |
| 12 | Wed Nov 7 | Overview of Storage and Indexing | Ch 13.{0-2}, Ch 14.{0-2}. | Project Progress Report due. slides (pdf). Exercise 18 (pdf). |
| 13 | Mon Nov 12 | Veteran's Day Holiday | ||
| 13 | Wed Nov 14 | Overview of Query Processing | Ch 16.1, Ch 15.{0-3}. | slides (pdf). Exercise 19 (pdf). |
| 14 | Mon Nov 19 | Overview of Query Processing | Ch 16.1, Ch 15.{0-3}. | Exercise 20 (pdf). |
| 14 | Wed Nov 21 | The Semi-structured Data Model & Programming Languages for XML | Ch 11.,Ch 12. | slides (pdf). Exercise 21 (pdf). |
| 15 | Mon Nov 26 | Special Topics | ics321-23-other. | |
| 15 | Wed Nov 28 | Project Presentation | ||
| 16 | Mon Dec 3 | Project Presentation | ||
| 16 | Wed Dec 5 | Final Exam Review | mock-final(pdf). |