Sample tables and an
installation script for all the exercises in the SQL chapter, Chapter 5. You
can get all tables and the script in one
zip file. Note that this material also exists customized for Microsoft
Access and Oracle (see below).

1) Slides for the Third Edition
in Powerpoint 95 format. All slides are available except the slides for
Chapter 24.

2) Installation manuals for
IBM DB2.

This material includes design documents,
installation guides for the application server, and complete source code for the projects.
This material is
currently available for IBM
DB2 and for Microsoft SQL Server 2000. We are working on versions for Oracle. The
following applications are available: Online Record Store, Online Pharmacy, Student Enrollment System,
and Airline Reservation System.

4) Solutions to exercises, both odd and even-numbered exercises (PDF
format, postscript)
up to Chapter 14. We are currently working on the remaining chapters.

5) Two extra SQL exercises

These SQL exercises can be used as SQL homework assignments for
students:

Student
registration system (contains full assignment text, a Microsoft
Access sample database, and files for bulk-loading sample relations into
other database systems). This assignment has been used several times at
Cornell University between 1999 and 2002.

Star Wars
(includes assignment text and a Microsoft Access sample database). This
assignment has been used at Cornell University between 1996 and 1999.

6) Sample Exams

We have a zip-file that contains nine exams from the Cornell undergraduate
database course CS432: Introduction to Database Management Systems from
1999-2002. Feel welcome to take any questions from these exams.