McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Student Solutions
Apache Installation Manual
Installation for Key Databases
Oracle User's Guide
Access Exercise Material
DB2 Application Material
Feedback
Help Center


Ramakrishnan: Database Management Systems Third Edition
Database Management Systems, 3/e
Raghu Ramakrishnan, University of Wisconsin
Johannes Gehrke, Cornell University


DB2 Application Material

Before installing any of the following applications, please read over and install IBM DB2 and Apache Tomcat following the instructions found in the Installation Manual for Apache (1145.0K).
 
Application 1:  The Internet BookShop
Description:  This is a simple bookshop website.  Customers can search the database for books, create a new account, add items to their shopping basket, and place an order.
Files:
File DescriptionFile Name (click to download)
Design Document:design_document.doc (308.0K)
Application Install Guide:application_server_install_guide.doc (111.0K)
Application Server Files, Version A:bookshop.zip (63.0K)
Application Server Class Files, Version A:bookshop_classes.zip (7.0K)
Application Server Files, Version B: (contains servlets)bookshop_2.zip (62.0K)
Application Server Class Files, Version B: (contains servlets)bookshop_classes_2.zip (12.0K)
 
Application 2:  The Student Registrar
(Only available for instructors)
Description:  The Student Registrar allows students of College University to view their course schedule, sign up for new classes, and modify their existing schedule.
Files:
File DescriptionFile Name (click to download)
Design Document: Design Document - The Student Registrar.doc
Application Install Guide: Application Server Install Guide - The Student Registrar.doc
Application Server Files: register.zip
Application Server Class Files: register-classes.zip
 
Application 3:  The Internet Airline
(Only available for instructors)
Description:  The Internet Airline is a simple airline reservation website. Customers can search the database for one-way and round-trip flights, create a new account, and place an order.
Files:
File DescriptionFile Name (click to download)
Design Document: Design Document - The Internet Airline.doc
Application Install Guide: Application Server Install Guide - The Internet Airline.doc
Application Server Files: airline.zip
Application Server Class Files: airline-classes.zip
 
Application 4:  The Online Pharmacy
(Only available for instructors)
Description:  The Online Pharmacy allows doctors and patients to create and order prescriptions.
  • Doctors view their patients' prescriptions, add new patients, create/modify prescriptions for their patients, and change their password.
  • Patients can view their prescriptions, order individual prescriptions, and change their password and shipping information. In addition, patients will be able to select their own doctor.
Files:
File DescriptionFile Name (click to download)
Design Document: Design Document - The Online Pharmacy.doc
Application Install Guide: Application Server Install Guide - The Online Pharmacy.doc
Application Server Files: pharmacy.zip
Application Server Class Files: pharmacy-classes.zip