DOC PREVIEW
UMBC CMSC 461 - CMSC 461 Course Project

This preview shows page 1-2 out of 6 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 6 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 6 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 6 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

CMSC 461: Database Management Systems Due July 7, 2005Course Project1 PurposeTo analyze the requirements, design, implement, d ocument and test a database applicationto automate an airline database system. The database system s hould perform the followingbasic functions:1. Let staff make entries when a passenger makes reservations on a flight.2. Let staff enter flight information before and after the flight including flight schedule,passenger check–in, passenger baggage loss information, etc.3. Let staff enter information on aircraft maintenance and details.The users of the application are staff members of the airline. It is assumed that all usershave network computers capable of running a modern Web browser.2 Information needsIn an airline database system, a number of different types of information need to be main-tained. They are classified according to th e activities that take place:• When a flight is schedu led, th e following in formation is needed:– Flight number– Date– Aircraft type(from those provided1)– Source city and state(from list of cities provided2)– Destination city and state(Give route if there are one or more intermediate stops)(from list of cities provided)– Scheduled departure time(s) and date(s)– Scheduled arrival time(s) and date(s)• Flight crew and other flight information has to be entered:1The possible types of aircraft are: Boeing 727, 737, 747 and Airbus A300, 320, 3402The cities in which the airline operates: New York, Washington D.C., Baltimore, L.A., San Francisco,Seattle, Chicago, Newark, Detroit, Boston, Raleigh, Tucson, Columbus, Tampa, Houston, Las Vegas, Min-neapolis, Atlanta, Pittsburgh and TorontoCourse P roject-I– Flight number– Date– Flight captain– Flight co–pilot– Flight engineer– Head steward/hostess– Number of seats booked– Fare information– Number of passengers on board– Fuel statusIt is assumed that none of th e flight crew change for the entire duration of the flight.• The following inform ation on the flight passengers is required:– Flight Number– Date– Social Security Number– First and last name– Age– Reservation status– Flight Class– Seat number– Amount charged– Choice of food– Contact address– Eligibility for frequent flier miles(Y/N)– Miles earned– Baggage inf ormation• The following inform ation on the flight passengers is required:– Flight Number– Date– Social Security Number– First and last name– Age– Reservation status– Flight ClassCourse Project-I I– Seat number– Amount charged– Choice of food– Contact address– Eligibility for frequent flier miles(Y/N)– Miles earned– Baggage inf ormation• For each aircraft owned/leased by the airline, th e following information needs to bemaintained:– Aircraft identification number– Bought/leased– Capacity of aircraft– Year of manufacture– Year of acquisition– Model number– Checked by– Date of last service– Category of aircraft service– Problems registered– Last FAA inspection date– Fuel requirements• For the pilots, flight engineer and stewards/air–hostesses, the following information isneeded:– SSN– First and last name– Contact address– Qualifications– Year of joining– Aircraft to fly/service– Date of last health checkup• Address should be maintained in the following format wherever appropriate:– Street– Apartment number– City– State– Zip– Telephone numbers(home and office)– Email addressCourse Project-I II3 FunctionsThe database application should be able to handle th e occurrence of the following events:• When a flight is scheduled, the following information is entered:– Flight number– Source, destination and intermediate cities and state(s)– Departure and arrival time(s) and date(s) at each city– Crew member information in the form– SSN– Duty• When a passenger books a ticket, the following information is entered:– SSN– Name– Contact address– Ticket type– Amount paid– Flying club member(Y/N)– Status of reservation(Confirmed/Waiting with waiting number)• Before a flight’s departure, the following in formation is entered/modified. This inf or-mation may be changed or entered at each intermediate city of the flight:– Departure time(s) and date(s) may be changed if the flight is re–scheduled– Arrival time(s) and date(s) may be changed if the flight is rescheduled– Fuel position– Ground engineer’s pre–flight check report(free text format)– Captain’s pre–flight report(free text format) When a passenger checks in, theinformation entered is:– SSN– Baggage carried– Seat number assigned• The following information needs to be entered/modified after the journey’s comple-tion:– Number of miles flown– Duration of flight– Captain’s post–flight reportCourse Project-IV– Ground engineer’s post–flight check report• If a passenger has any complaints or some baggage–related problems, it should berecorded and mo dified as:– SSN– Baggage missing– Status of missing baggage– Comments(complaints noted)4 Materials to submitWhen the project is completed, a project repost and any code needs to be submitted. Youalso need to demonstrate the database app lication.4.1 Project ReportThe project is to be done in five phases. The P roject report should have a separate sectionfor each phase. The project phases are:1. Analysis of the requirements of the project and a high–level description of the tasksinvolved.2. This phase involves the following• Develop an Entity–Relationship model detailing the relations involved.• Identify the attributes of the entities and the relations along with the primarykey for each entity.• List the constraints for each relation and entity.• Give details of th e procedures that you will implement in the database applica-tion.You should be able to explain the reasons for the particular design approach you havechosen.3. This phase involves the following:• Design an Oracle database based on the design developed in section B.• Implement SQL tables for the relations and the constraints. Maintain scripts forthe creation of tables.• Submit pseudo–code for the procedures that you will develop.• Justify your design choices.4. This phase consists of the following:• Write Java code to access, update and administer SQL tables made.Course Project-V• Develop a user interface, using which each of these functions should be


View Full Document

UMBC CMSC 461 - CMSC 461 Course Project

Download CMSC 461 Course Project
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view CMSC 461 Course Project and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view CMSC 461 Course Project 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?