Flight+Schedules

=Flight Schedules - Kieran= Main function: The Main function of a Flight Schedule is to create an order in which planes would use the runway at the airport. Because there are so many flights in a day, there is a high risk of collisions above or on the runway. The Flight Schedule most be constantly updated to accommodate weather delay's, tardy flights and emergency landings.

Database Data List
 * 1) Plane Number
 * 2) Type of Plane
 * 3) Airline (Company)
 * 4) Flight Number
 * 5) Departure Time
 * 6) Arrival Time
 * 7) City Taking Off From
 * 8) City Arriving In
 * 9) Airport Arriving In

Unique Key/Identifier -Flight Number

What system would use data from this system? -Air traffic control would use the data to keep track of which flights each air traffic controller will be responsible for at a specific time -The FIDS system would use data from this system to display the flight information to passengers -The billing system would use this data to accurately bill customers buying tickets as the time of the flight and it's destination effect the price of the flight. -Ground services would use this data to know which flights need to be refueled, catered, etc at certain times -Handling agents would use this data to help customers book flights closest to the time the customer wants to leave -Staff information would use this information to staff the flights with employees that will be free to work on the flight and won't be on another flight at the same time -Baggage system would use this data to accurately and efficiently ship baggage to the flights