CSC 343

INTRODUCTION TO DATABASES

WINTER 2003

Professor: Leonid Libkin
Room: PT398A
Office hours: TBA

Class meets: Mondays 4-6pm, GB 248
Tutorials: Wednesdays 3-4pm; (A-Le) in GB 248, (Li-Z) in GB 304

Tutors:  Ariel Fuxman,   Ken Hoetmer,   Phuong Nguyen,   Yannis Velegrakis

Requirements: Homeworks (45%), Midterm (15%), Final exam (40%)

Syllabus

Announcements


Homeworks and Exams

Homework 1         Solutions       

Homework 2         A guide to DB2 on CDF    Solutions

Midterm solutions

Homework 3         DDL statements     Solutions

Final Exam - Solutions

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)

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

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