Develop flight schedule application for fly-by-night airline

Reference no: EM131459688

Assignment

You have been asked to develop a Flight Scheduling application for the Fly-By-Night Airline. The Airline has one or more flights per day but they are not by time. Every Flight will be available for each day the airline flies. The customer gets booked on a specific flight for a specific day. Each Flight has a name and a number of seats on the flight. Each date is just a specific day. The Customer is identified by a single name.

This application should have a very nice GUI interface and will be a database driven application. The database used will be Derby. This application must use good Object Oriented Design and Programming. The database must use good Object-Oriented Design and Programming. There is a very close correlation between Object-Oriented Design and Database Design. Your application design should include at least four classes besides the main GUI class, e.g. Flight class, Day class..., Bookings class, etc. Your database accesses should be in the classes that correlate with the database tables.

This assignment is the first half of the final project and will be submitted as Programming Assignment 6. This phase of the project will implement the following user commands:

Book Customer Day Flight

The customer will be assigned the flight for the requested day, if there are seats available. If seats are not available, the customer will be put on the wait list for that flight. The waiting list must be maintained in the order the customers tried to book their flights.

Status Flight Day

The Status command for flight and day will display the customers that have been booked for that flight on that day.

Status Waiting List by Day

The Status command for the Waitlist will display all the customers waiting for flights on the specified day.

Database considerations:

The Flight Table should be preloaded with several flights such as F101, G102 and the number of seats on the flight. Two seats per flight would be suggested to make testing easier.

The Day Table should be preloaded with several days of your choice.

The database tables should not contain redundant data, i.e. relevant data should only appear in one table.

Reference no: EM131459688

Questions Cloud

What is the task-objective budgeting method : What is the task-objective budgeting method? Describe its two steps. The task-objective method develops a promotional budget based on an evaluation of the firm.

What is the direct sales results test : What is the direct sales results test? The direct sales results test reveals the specific impact on sales revenues for each dollar of promotional spending.

Calculate the change in income : Calculate the change in income if government spending increases by 10 - Why is there a difference between the government expenditure multiplier and transfer payment multiplier?

Write about german history paper : Then relate these general characteristics of Expressionism to the formal characteristics of Wiene's film and to the film's socio-political "message."

Develop flight schedule application for fly-by-night airline : You have been asked to develop a Flight Scheduling application for the Fly-By-Night Airline. The Airline has one or more flights per day but are not by time.

Compare the consumer surplus : What is the lowest that the firm will charge and how many units will the firm sell?

How would you suggest monitoring and stabilizing : What is the anticipated need for change based on the happy hour scenario - How would you, as the OD consultant, approach the employees and management to build a relationship?

Describe how genetic algorithms might be used : Describe how genetic algorithms might be used in the development and production of a new product that is a complex system, such as a self-driving car.

Multiple intelligences affect our performance : How do multiple intelligences affect our performance? Please explain.

User Account

All Pages