Develop flight scheduling application for fly-bynight airlie

Reference no: EM131299171

Flight Scheduler Initial Phase - Programming 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. 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.

GUI Guidelines:

The user should be required to enter only unknown data. Drop down lists of known data such as Flight names or Days should be displayed for the user to select from.

Combo Boxes should be used to categorize data on the form. When information is requested to be displayed e.g. for a Status command, all of the requested information must be displayed. When a command is performed, the results of that command should be displayed to the user without the user needing to check Status to see what was done.

Reference no: EM131299171

Questions Cloud

Prove that the voltage drop across the loop filter resistor : Assume Vcont can vary from 0 to VDD. Prove that the voltage drop across the loop filter resistor reaches roughly 1.6πVDD if no second capacitor is used.

Is the variable state categorical or quantitative : Is the variable "state" categorical or quantitative? To show the distribution of these data, would you use a pie chart or a bar graph?

Find the equations for marginal revenue curve : a. Find the equations for marginal revenue curve and the marginal cost curve. b. Find the profit maximizing level of output and the profit maximizing price. At this combination, what is the level of firm profit? What is the level of deadweight loss..

Critically analyze the part of an information security audit : Information Security Audit (COMP 0392) - The auditor should have a sufficient knowledge about the company and its critical business activities before starting an audit review. Critically analyze the part of an Information Security auditor towards ..

Develop flight scheduling application for fly-bynight airlie : 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.

Market clearing device in rural credit markets : How does your answer to A) change if the probability of repayment falls to 60%? In the context of this application, explain why interest rates are often not used as a market clearing device in rural credit markets.

Explain from given equation what happens to output sidebands : A PLL is designed with an input frequency of 1 MHz and an output frequency of 1 GHz.- Explain from given Equation what happens to the output sidebands.

What is the real interest rate : In 1999, the Canadian economy was at full employment. Real GDP was $886 Billion, the nominal interest rate was around 6 percent per year, the inflation rate was 2 percent a year, the price level was 110, and the velocity of circulation was constan..

Write a research article critically analysing it strategy : The purpose of the task is to understand the significance of Smart Mobility, and explore their connection with IS-IT strategy. Write a research article critically analysing IS/IT strategy frameworks/models.

User Account

All Pages