| Week | Date | Topic | Readings | Remarks |
|---|---|---|---|---|
| 1 | Mon Jan 10 | Course Organization | slides (pdf) | [v1] Data Explosion | [v2] EMC Greenplum | |
| 1 | Wed Jan 12 | The Worlds of Database Systems | Ch.1 | slides (pdf) | Exercise 1 (pdf) |
| 2 | Mon Jan 17 | Holiday: MLK | ||
| 2 | Wed Jan 19 | The Relational Model of Data | Ch.2 |
Quiz 1 due at 11:30am slides (pdf) | Exercise 2 (pdf) |
| 3 | Mon Jan 24 | The Relational Model of Data | Ch.2 |
Quiz 2 due at 11:30am
Bring your laptops. db2 commands (txt) slides (pdf) | Exercise 3 (html) |
| 3 | Wed Jan 26 | Design Theory for Relational Databases | Ch.3 | slides (pdf) | Exercise 4 (pdf) |
| 4 | Mon Jan 31 | Design Theory for Relational Databases | Ch.3 |
Quiz 3 due at 11:30am
slides (pdf) | Exercise 5 (pdf) |
| 4 | Wed Feb 2 | Design Theory for Relational Databases | Ch.3 |
slides (pdf)
| Bring back Exercise 5.
Solutions to Ex 5 (txt). |
| 5 | Mon Feb 7 | High Level Database Models | Ch.4 |
Quiz 4 due at 11:30am
slides (pdf) | Exercise 6 (pdf) |
| 5 | Wed Feb 9 | High Level Database Models | Ch.4 ODL is out. | Bring Ex. 6 back to class. slides (pdf) |
| 6 | Mon Feb 14 | Algebraic and Logical Query Languages | Ch.5 | Quiz 5 due at 11:30am slides (pdf) | Exercise 7 (pdf) |
| 6 | Wed Feb 16 | Algebraic and Logical Query Languages | Ch.5 | slides (pdf) | Exercise 8 (pdf) Assignment 1 due 2355 hour |
| 7 | Mon Feb 21 | Holiday: President's day | ||
| 7 | Wed Feb 23 | The Database Language SQL | Ch.6 |
Quiz 6 due at 11:30am
slides (pdf) | Exercise 9 (pdf) |
| 8 | Mon Feb 28 | Pre-Midterm Review | Quiz 7 due at 11:30am | |
| 8 | Wed Mar 2 | Mid-term Exam | Project Proposal due on Fri Mar 4 at 2359 hr | |
| 9 | Mon Mar 7 | Post-Midterm Review | ||
| 9 | Wed Mar 9 | The Database Language SQL | Ch.6 | slides (pdf) | Exercise 10 (pdf) |
| 10 | Mon Mar 14 | The Database Language SQL | Ch.6 |
Quiz 8 due at 11:30PM.
slides (pdf) | Exercise 11 (pdf) |
| 10 | Wed Mar 16 | The Database Language SQL | Ch 6. | slides (pdf) | Exercise 12 (pdf) |
| 11 | Mon Mar 21 | Spring Break | ||
| 11 | Wed Mar 23 | Spring Break | ||
| 12 | Mon Mar 28 | Overview of Transaction Processing | Ch 18.1 |
Quiz 9 due at 11:30 am. slides (pdf) | Exercise 13 (pdf) |
| 12 | Wed Mar 30 | Ch.9 | SQL in a Server Environment |
Assignment 2 due 2355 H
Project Progress Report due on Fri Apr 1 2359 hr Quiz 9 is due at 11:30AM. Slides (pdf) | Exercise 14 (pdf) | sqc.zip (zip) | odbc.zip (zip) | jdbc.zip (zip) SQC Screencast for compiling and running the sqc sample program. JDK Screencast for installing jdk in ubuntu. ODBC Screencast for compiling and running the sample ODBC program. JDBC Screencast for compiling and running the sample JDBC program. |
| 13 | Mon Apr 4 | Constraints, Triggers, Views, Indexes | Ch.7,8 |
Quiz 10 is due at 11:30AM. Slides (pdf) | Exercise 15 (pdf) |
| 13 | Wed Apr 6 | Overview of Storage and Indexing | Ch 13.{0-2,3.{1-2}}, Ch 14.{0-3} | Slides (pdf) | Exercise 16 (pdf) |
| 14 | Mon Apr 11 | Overview of Storage and Indexing | Ch 13.{0-2,3.{1-2}}, Ch 14.{0-3} | Slides (pdf) Bring back Exercise 16. |
| 14 | Wed Apr 13 | Overview of Storage and Indexing | Ch 13.{0-2,3.{1-2}}, Ch 14.{0-3} |
Exercise 17 Project Info (pdf) | Project Presentation Template(pdf) | (pptx) |
| 15 | Mon Apr 18 | Overview of Query Processing | Ch 16.1, Ch 15.{0-3} | Slides (pdf) | Exercise 18 (pdf) |
| 15 | Wed Apr 20 | Overview of Query Processing | Ch 16.1, Ch 15.{0-3} |
Exercise (pdf)
Commands (txt) |
| 16 | Mon Apr 25 | The Semi-structured Data Model | Ch. 11+12 | Slides (pdf) | Exercise (pdf) |
| 16 | Wed Apr 27 | Project presentation | ||
| 17 | Mon May 2 | Project presentation | ||
| 17 | Wed May 4 | Final Exam Review |