Create a database of all seats and flights

Assignment Help Database Management System

Reference no: EM13713864

Question - You have been asked by an airline to develop a reservation system program for specific flights.

A customer should be able to select from one of four categories of seats on flights from RDU to any of at least three other destinations.

Based on the user input of seat type and destination, the number of seats of that type on that flight should be decreased and the appropriate fare should be displayed to the customer.

Customers should not be able to select a sold out seat type on a particular flight and should be alerted if seats are sold out. Remaining seats available on a particular flight should be displayed properly.

So far this is what I have put together i know it is not much, Select one of four categories of seats, need to create four different seats.

Starting destination is RDU chart at least three destinations, a step in purchasing is user selecting a seat type followed by a destination.

Create a database of all seats and flights and keep track of sold/unsold of all 4 categories of seats.

- Show cost of chosen seat/flight combo options

- Email alerts when seats/flights are sold out.

- Show all available seats and flights in real time.

Please don't just post a web url or screenshot of a website, I want it in a reader friendly format.

Reference no: EM13713864

Questions Cloud

How much acyclovir is needed by the patient : Weight of Patient: 176 lbs RX: Acyclovir 5mg/kg in 250ml NS; infused at a constant rate over 1 hour. How much Acyclovir is needed by the pt

Computes all magic numbers : Write a program that, for any upper limit, computes all magic numbers less than that limit - A magic number is defined as a positive integer which is equal to the sum of its own factors

Explain how much co2 is produced by a car driven : How much CO2 is produced by a car driven 20000 miles in one year. Assume the car gets 20mi/4L of gas, gas has the chemical formula of octane, one liter of gas has a mass of .8kg, gas is completely burned to CO2 and H2O

Human creativity from the era covered by the learning plan : 1.Your presentation includes one example of human creativity from the era covered by the learning plan. 2.Your presentation includes one slide that represents the example chosen (an image)

Create a database of all seats and flights : Create a database of all seats and flights and keep track of sold/unsold of all 4 categories of seats - Show cost of chosen seat/flight combo options

What information you use, besides the financial statements : What information might you use, besides the financial statements of an organization, when analyzing its financial health

Explain what pressure does the methane exert on the walls : A gas cylinder containing 1.50 mol compressed methane has a volume of 3.30 L. What pressure does the methane exert on the walls of the cylinder if its temperature is 25°C

Compute the average grades : Prepare a program that allows a teacher to compute the average grades for EACH student in his or her class

Implications of health economic concepts for healthcare : Select at least five (5) economic concepts covered in the first four weeks' readings, and discuss the primary manner in which these concepts impact the world of health care economics. Some examples of selected concepts are health demand and supply..

User Account

All Pages