CSC 343

INTRODUCTION TO DATABASES

FALL  2004

Professor: Leonid Libkin
Room: PT398A
Office hours: Tuesdays 3-4:30pm

Class meets: Tuesdays 1-3pm, SF1101
Tutorials: TBA

Tutors:
Solmaz Kolahi (t3kolahj @ cdf.toronto.edu)
Cristiana Chitic (t4chitic @ cdf.toronto.edu)
Elham Fazli (t4fazlie @ cdf.toronto.edu)
Pablo Barcelo (t4barcel @ cdf.toronto.edu)
Lan Hui (t3lanhui @ cdf.toronto.edu)
Sultan Mujahid (t4sultan @ cdf.toronto.edu)
Wan Pengcheng (t4wanpen @ cdf.toronto.edu)

Requirements: 3 homeworks, including 2 assignments on db2,
                        3 in-class tests. Weights and further details
                        are in the syllabus.

Syllabus

Announcements


Homeworks and Exams

Partial credit policy

Homework 1   Solutions

Test1 - Solutions

Homework 2 announcement     Homework 2     DDL for HW2    DB2 instructions   Additional db2 examples   DB2 resources

Test2 - Solutions

Homework 3   Solutions parts 2 and 3    Embedded SQL solutions

FINAL TEST - PLEASE READ!     Solutions   Final test marks

Marks

Tutorials


For tutorials, we mostly use exercises from Database Management Systems  by Raghu Ramakrishnan and Johannes Gehrke.

Some of them are available on-line here.


Transparencies

Set 1 (DBMS architecture, relational query languages)     (2 slides per page)     (4 slides per page)

Set 2 (SQL - introduction)     (2 slides per page)     (4 slides per page)

Set 3 (SQL - advanced concepts)     (2 slides per page)     (4 slides per page)     Tutorials

Set 4 (Database constraints and database design)     (2 slides per page)     (4 slides per page)    

Set 5 (Query and transaction processing)     (2 slides per page)     (4 slides per page)