 |  Database Management Systems, 3/e Raghu Ramakrishnan,
University of Wisconsin Johannes Gehrke,
Cornell University
DB2 Application Material
| 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.
| |
| 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 Description | File 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 Description | File 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 Description | File 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 |
|
|
|
|