Create a database of all seats and flights and keep track


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.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Create a database of all seats and flights and keep track
Reference No:- TGS0967117

Expected delivery within 24 Hours