| Week | Date | Topic | Readings | Remarks |
|---|---|---|---|---|
| 1 | Mon Aug 23 | Course Organization and Introduction | None | Slides (pdf) | Exercise 1 (pdf) |
| 1 | Wed Aug 25 | The Worlds of Database Systems | Ch.1 |
|
| 2 | Mon Aug 30 | The Relational Model of Data | Ch.2 |
Quiz 1 is due before class at 11AM Screencast Tutorial on Installing Ubuntu in a VirtualBox VM. Screencast Tutorial on Installing DB2 in Ubuntu. Slides (pdf) | Exercise 2 (pdf) |
| 2 | Wed Sep 1 | The Relational Model of Data | Ch.2 |
Bring your laptops.
Slides (pdf) | Exercise 3 (html) db2 commands (txt) Unix Command Summary |
| 3 | Mon Sep 6 | Labor Day Holiday | Quiz 2's window is pushed back to Tuesday. | |
| 3 | Wed Sep 8 | Design Theory for Relational Databases | Ch.3 |
Quiz 2 opens on Tue 11AM and is due on Wed at 11AM.
Slides (pdf) | Exercise 4 (pdf) |
| 4 | Mon Sep 13 | Design Theory for Relational Databases | Ch.3 |
Quiz 3 is due at 11AM.
Slides (pdf) (updated) | Exercise 5 (pdf) |
| 4 | Wed Sep 15 | Design Theory for Relational Databases | Ch.3 3.{6-} not in syllabus. |
Bring Exercise 5 back to class.
Slides (pdf) Solution to Exercise 5 (txt) |
| 5 | Mon Sep 20 | High-Level Database Models | Ch.4 |
Quiz 4 is due at 11AM.
Bring Exercise 5 back to class. BCNF decomp algo (png) | 3NF decomp algo (png) Slides (pdf) | Exercise 6 (pdf) |
| 5 | Wed Sep 22 | High-Level Database Models | Ch.4 ODL is not in syllabus. |
Bring Exercise 6 back to class. Laptops would help, but not critical.
Slides (pdf) |
| 6 | Mon Sep 27 | Algebraic and Logical Query Languages | Ch.5 |
Quiz 5 is due at 11:30AM. (Extended till 23:59 hour) Slides (pdf) | Exercise 7 (pdf) |
| 6 | Wed Sep 29 | Algebraic and Logical Query Languages | Ch.5 |
Assignment 1 due.
Slides (pdf) | Exercise 8 (pdf) |
| 7 | Mon Oct 4 | The Database Language SQL | Ch.6 |
Quiz 6 is due at 11:30AM. Slides (pdf) |
| 7 | Wed Oct 6 | Mid-term Review | Ch.6 | Ex 3.2.10, 3.3.1, 3.5.1 |
| 8 | Mon Oct 11 | Mid-term Exam | ||
| 8 | Wed Oct 13 | Post Mid-term Exam Review | Ch.6 | Project Proposal Due on Friday Oct 15 23:59 hours. |
| 9 | Mon Oct 18 | The Database Language SQL | Ch.6 |
Quiz 7 is due at 11:30AM. Slides (pdf) | Exercise (pdf) |
| 9 | Wed Oct 20 | The Database Language SQL | Ch.6 |
Slides (pdf)
|
Exercise (pdf)
Pics of sample data can be found in Exercise 3 (html) Screencast Tutorial on using DB2 in Ubuntu. |
| 10 | Mon Oct 25 |
The Database Language SQL Overview of Transactions |
Ch.6 18.1 |
Quiz 8 is due at 11:30AM. Sample scripts for Ex 10 (zip) Slides (pdf) |
| 10 | Wed Oct 27 | Overview of Transactions | Ch.6 & 18.1 |
Assignment 2 due on Sunday Oct 31 at 23:55 hours.
Screencast showing how to use ssh and scp to submit assignment.
Slides (pdf) | Exercise (pdf) |
| 11 | Mon Nov 1 | SQL in a Server Environment | Ch.9 |
Quiz 9 is due at 11:30AM. Slides (pdf) | Exercise 12 (txt) | sqc.zip (zip) SQC Screencast for compiling and running the sqc sample program. |
| 11 | Wed Nov 3 | SQL in a Server Environment | Ch.9 |
Slides (pdf)
|
odbc.zip (zip)
|
jdbc.zip (zip)
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. |
| 12 | Mon Nov 8 | Constraints, Triggers, Views, Indexes | Ch.7,8 |
Quiz 10 is due at 11:30AM. Slides (pdf) Project Info (pdf) | Project Presentation Template(pdf) | (pptx) |
| 12 | Wed Nov 10 | Overview of Storage and Indexing | Ch 13.{0-2,3.{1-2}}, Ch 14.{0-3} |
Project Progress Report due at 23:59 hours. Slides (pdf) | Exercise (pdf) |
| 13 | Mon Nov 15 | Overview of Storage and Indexing | Ch 13.{0-2,3.{1-2}}, Ch 14.{0-3} |
Quiz 11 is due at 11:30AM. Slides (pdf) | Exercise (pdf) |
| 13 | Wed Nov 17 | Overview of Query Processing | Ch 16.1, Ch 15.{0-3} | Slides (pdf) | Exercise (pdf) |
| 14 | Mon Nov 22 | The Semi-structured Data Model | Ch. 11+12 |
Quiz 12 is due on Wed Nov 24 6:00AM. Slides (pdf) | Exercise (pdf) |
| 14 | Wed Nov 24 | Other Data Models: Unstructured, Graph, Key-Value Pairs | Slides (pdf) | |
| 15 | Mon Nov 29 | Project Presentation | Quiz 13 due at 11:30 AM. | |
| 15 | Wed Dec 1 | Project Presentation | ||
| 16 | Mon Dec 6 | Project Presentation | ||
| 16 | Wed Dec 8 | Final Exam Review |
