343 Introduction to Databases: Fall 2003

Section L5101 / L2002

Course Description

Concepts, approaches, and techniques in data base management systems (DBMS): relational data bases, querying and updating a data base, query language SQL, data base constraints and data base design, elements of data base technology.

Prerequisites: CS263H1/265H1(228H1,238H1)/378H1; CGPA 3.0 proficiency in C

Instructor: Laurent Mignet
Email: mignet@cs.toronto.edu
Room: BA 5222
Office hours: Tuesday 5:00pm - 6:00pm; Wednesday 5:00 pm - 6:00 pm

Class meets: Wednesday 7-9pm, MC 102 (the class room has changed)
Tutorials: UC 52 & WI 524

Final Test: December 3rd 2003 in MC 102 from 7:00 pm to 9:00 pm

Tutors:
   Solmaz Kolahi
   Ken Pu
   Yousuf Shamim Ahmed

Unoffical Final Mark

Tutorials

The questions and solutions for the tutorial can be found at this address: Database Management Systems by Raghu Ramakrishnan and Johannes Gehrke

Tutorial Group:
[A-O]: Room WI 524
[P-Z]: Room UC 52

DB2:

Newsgroup: ut.cdf.csc343h

Syllabus

Announcements (last updated November 6th)

Where is L0101 section?

Assignments

Assigment 1 (Due Date October 2nd 5:00 pm) Solution
Assigment 2 (Due Date October 30th 5:00 pm). For this assignment you must use the following cover page and repeat it if you use an envelope. You will not be given any credits for anything written using a pencil Solution (given as it. They are not complete)
- DB2 on CDF
Assignment 3 (due date November 20th 5:00 pm). For this assignment you must use the following cover page and repeat it if you use an envelope. You will not be given any credits for anything written using a pencil.
- Solution
- Makefile A sample of a Makefile is given at this link
- To execute an embedded SQL program do not forget to add this line to your configuration file (.cshrc) and login again: "setenv LD_LIBRARY_PATH /usr/IBMdb2/V7.1/lib/"

Tests

Test 1 (Made October 8th) Solution
Test 2 (Made November 5th) Appendix Solution
Solution Test 3 (Made December 3rd) Appendix

Slides

Transparencies

Set 1 (DBMS architecture, relational query languages) (2 slides per page) (4 slides per page) [Copyright Libkin 2003] [updated September, 25th 2003 ]

Set 2 (SQL) (2 slides per page) (4 slides per page) [Copyright Libkin 2003] [updated October, 1st 2003 ]

Set 3 (Normalization) (2 slides per page) (4 slides per page)

Set 4 (Constraint - Assertion - Triggers) (2 slides per page) (4 slides per page) [Copyright Libkin 2003] [updated November, 12th 2003 ]

Set 5 (Query Processor & Transaction) (2 slides per page) (4 slides per page) [Copyright Libkin 2003] [updated November, 12th 2003 ]

Remarks

Email The simpler your message, the faster it will be answered: in general, if you send an email you SHOULD put "CS 343" in the subject field before any other words. Sending a query/program formatted as one line and asking "what's wrong with it?" is unlikely to be answered, ever (even by a TA). Sending html (modern email are especially guilty of that) is also unlikely to result in an answer.

Note: To create the differents materials involved in this course I used these very useful site: