Note: The week of March 11, my office hours will be on Monday, 2-4pm.

Class meets: Wednesdays 7-9pm, SS 2102
Tutorials: Wednesdays 6-7pm

Tutors:  Periklis Andritsos,  Denilson Barbosa, Ramona Truta, Yannis Velegrakis

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

Syllabus
 

Homework 1         Solutions       

Homework 2         A guide to DB2 on CDF     Solutions part 1     Solutions part 2

Midterm         Solutions

Homework 3         Solutions

Final Exam - Solutions

Unofficial final marks

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 (Query and transaction processing)     (2 slides per page)     (4 slides per page)     Tutorial notes

Set 5 (Topics: incomplete information and null values; OODBs, databases on the web)     (2 slides per page)     (4 slides per page)