Database Management Systems

by Raghu Ramakrishnan and Johannes Gehrke

Database Management Systems (3rd Edition) ]

Supporting Material for the Third Edition

Material for Students and Instructors

The following material is available free to download for students and instructors:

Material for several commercial database systems:

Oracle:

Microsoft Access:

IBM DB2:

Microsoft SQL Server:

Material Available Only for Instructors

The following material is available free to download only to instructors. (How do I get access to instructor's materials?)

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.

3) Internet hands-on course projects. (This is material for Chapters 6 and 7.)

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.

  • Material for DB2 (design documents, installation guides, complete source code for four sample applications)
  • Material for Microsoft SQL Server 2000 (design documents, installation guides, complete source code for four sample applications)

We have also a quick-start guide for setting up Tomcat available.

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.