University of Toronto, Winter 2011

INF1343: Data Modeling and Database Design

Syllabus and Readings

The course syllabus is here.

The two books are available online through the UofT library: SQL and RDD. You can also buy a copy in the U of T book store.


March 25, 2011

Here is a practice final exam.

March 14, 2011

Here is a revised version of the CGI example and the updated instructions on installing it. This version has has more comments and is a bit more complicated than the earlier one. You can use it as a basis for your own web interface. (Updated at 7:35 pm on March 14.)

March 9, 2011

Here are the details on handling external transfers in your final projects, including sample files.

February 28, 2011

Examples from today's class are here: (The installation instructions are the same as the previous week.)

February 27, 2011

The answers to assignment 2 are here.

February 14, 2011

Here is the final CGI file we used in class, and the instructions on installing it.

February 11, 2011

The final project assignment is here.

Febuary 7, 2011

Here is the code from today's lecture: university.sql.

Febuary 7, 2011

Here are the answers to Assignment 1. The last slide of today's slide stack has the distribution.

January 24, 2011

Assignment 2 is now available and is due on February 14.

January 10, 2011

Assignment 1 is now available and is due on January 24.


All effort will be made to post slides before class. On some days we might end up not getting through all the slides planned for the lecture. In this case, you will see those slides repeated in the next week's presentation. Slide files uploaded before the class will be updated to correct any inaccuracies or sometimes to add information that was presented in class interactively. Such slides will be marked with an *. They won't be updated, however, just to remove the slides that we didn't get through.

Week 1: PDF*, ODP* Week 5: PDF, ODP Week 9: PDF, ODP
Week 2: PDF*, ODP* Week 6: PDF*, ODP* Week 10: PDF*, ODP*
Week 3: PDF*, ODP* Week 7: PDF*, ODP* Week 11: PDF, ODP
Week 4: PDF*, ODP* Week 8: PDF, ODP Week 12: PDF, ODP