Class meets: Thursdays 7-9pm, RW117
Tutorials: Thursdays 6-7pm

Tutors:  Periklis Andritsos,  Kiran Chaudhry, Themistoklis Palpanas,Yannis Velegrakis

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

Syllabus
 

Homework 1         Solutions

Homework 2         A guide to DB2 on CDF     Solutions (part I)     Solutions (part II)

Midterm         Solutions

Homework 3         Solutions

Final Exam         Solutions

Final marks

Set 1 (introduction, queries)

Set 2 (conjunctive queries, simple SQL, relational algebra)

Set 3 (Full relational calculus, algebra)

Set 4 (SQL)

Set 5 (Database constraints)

Set 6 (Database design)

Set 7 (Query processing and optimization)     Tutorial notes

Set 8 (Transactions and Concurrency Control)

Set 9 (Incomplete Information and Null Values)

Set 10 (OODBs, databases on the web)