CSC 343

INTRODUCTION TO DATABASES

FALL 2002

Professor: Leonid Libkin
Room: PT398A
Office hours: Mondays 1:30-3:30pm

Class meets: Mondays 7-9pm, BA 1180
Tutorials: Mondays 6-7pm

Tutors:  Kenneth Hoetmer, Themis Palpanas, Miles Trochesset, Zheng Zhang

Requirements: Homeworks (40%), Midterm (20%), Final exam (40%)

Syllabus

Announcements

My office hours on Monday December 9 will be 2:30-4:30pm


Homeworks and Exams

Homework 1         Solutions       

Homework 2         A guide to DB2 on CDF     Submission instructions     Solutions

Midterm solutions

Homework 3         Submission instructions        DDL statements     Extension    Solutions

Final Exam - Solutions

Marks

Unofficial final marks


Transparencies

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

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

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

Set 4 (SQL in the real world)     (2 slides per page)     (4 slides per page)

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