Available Flight Database

1
Data Structure Diagrams
Databases
Available Flight Database
Reservation Database
Available Flight Database
Reservation Database
Available Flight
Reservation And Issued Ticket Information
Available Seat by Class
Flight Information
Reservation Information
Issued Ticket Information
Issued Date and Time
Salesperson
Name of Ticket Counter
Total of Seat Count
Available Seat Count
Flight Master
Flight Master
Flight Management Record
Flight Information
Boarding Gate Number
E-23
2
Seat Database
Seat Database
Seat Information
Flight Number
Flight Date
Seat Class
Seat Type
Seat Number
Customer Information
Smoking /Non Smoking
Window Seat /Aisle Seat /Other Seat
Money-back-Rate-Table
Money-Back-Rate?Table
Money-Back-Rate
Service Charge
Money-Back-Rate by days to Departure
Days to Departure
E-24
3
Data Flows
Available Flight Information
Available Flight Information
Flight Information
Departure Date and Time
Arrival Date and Time
Departure Place
Arrival Place
Fare Information
Flight Number
Available Seat Information
Seat Class
Fare
Flight Information to be Reserved
Flight Information to be Reserved
Available Seat Information
Seat Information
Flight Information
E-25
4
Reservation Information
Reservation Information
Reservation Number
Flight Number
Departure Date
Seat Class
Customer Information
Reception Information
Reception Date and Time
Expiration of Reservation
Person in Charge
Reception Office
E-26
5
Flight Ticket
Flight Ticket
Issued Date and Time
Customer Infromation
Reservation Number
Flight Information
Number of Counter
Boarding Pass
Boarding Pass
Boarding Gate Number
Flight Ticket
Reserved Seat Information
Seat Number
Seat Class
Seat Type
E-27
6
Passenger Information
Customer Information
Customer Information
Passenger Information
Customer Information
Telephone Number
Age
Sex
Name
E-28
7
The Configuration of CURRENT SYSTEM
Ticket Counter
Check-in Counter
Issuing Tickets Refund
Check-in
WAN
Reservation Center
System Center
Reservation
Database Maintenance Batch Processing
E-10