Class meets: Mondays 4-6pm, SF1105

Tutors: TBA

Requirements: 3 homeworks, including 2 assignments on db2,
                        3 in-class tests. Weights and further details
                        are in the syllabus.

Syllabus

Announcements

DB2 instructions   Additional db2 examples   DB2 resources

Homework 2        DDL for  Hw2

Homework 3   DDL for homework 3  selected solutions

FINAL IN-CLASS TEST: Monday 4 April, 4:10pm, BA 2155 (A-L), BA 2175 (M-Z)
please do NOT go to the usual class room!

Final test - solutions

Grades should be availabe here. They are not up to date.

Some of them are available on-line here.

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)