CSC 343

INTRODUCTION TO DATABASES

FALL 2003

Professor: Leonid Libkin
Room: PT398A
Office hours: Tue 3:15-5pm

Class meets: Tuesdays 1-3pm, WB 116
Tutorials:  Thursdays 1-2pm; (A-L) in WB 116, (M-Z) in BA1130

Tutors:  Ken Hoetmer, Pablo Barcelo, Ramona Truta, Yannis Velegrakis

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

Test 1 - solutions

Homework2       DB2 instructions   Additional db2 examples  Solutions

Homework    Solutions embedded SQL solutions

DB2 resources

Test 2 - solutions 

Test 3      Test 3 - solutions

Unofficial final 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)