The project “Airline Management System” comprises of a large number of flights which belong to a particular airline. It enables us to add any number of records in our database.Ĭreate table cancellation(pnr_no varchar(10), cancellation_no varchar(10), cancellation_date DATE, fli_code varchar(15)) Ĭreate table flight(f_code varchar(10), f_name varchar(20), src varchar(30), dst varchar(30)) Ĭreate table login(username varchar(20), password varchar(20)) Ĭreate table passenger(pnr_no varchar(10), address varchar(30), nationality varchar(15), name varchar(20), gender varchar(10), ph_no varchar(15), passport_no varchar(20), fl_code varchar(10)) Ĭreate table payment(pnr_no varchar(10), ph_no varchar(15), cheque_no varchar(15), card_no varchar(20), paid_amt varchar(10), pay_date DATE) Ĭreate table reservation(pnr_no varchar(10), ticket_id varchar(10), f_code varchar(10), jny_date DATE, jny_time varchar(10), src varchar(20), dst varchar(20)) Ĭreate table sector(flight_code varchar(20), capacity varchar(10), class_code varchar(5), class_name varchar(20)) For data storage and retrieval we use MySQL Database. The system also allows us to add records when a passenger reserves a ticket.
The system is able to provide much information like passenger’s information, criminal’s, list of all passengers etc. This project on Airline Management System is the automation of registration process of airline system.
0 kommentar(er)
