01. Customer
Cus_ID, Name(First Name, Last Name), Gender, E-mail, Address(Code, Street name, City), Age, DOB
02. Admin
Admin_ID, Name(First_name, Last_name), Address(code,Street_name,city), Gender, Age, DOB
03. Ticket
Ticket_no, Payment_method(credit, debit, mannual), Class(First, Business, Economy)
04. Passenger
Passport_No, Name(First_name, Last_name), Email, Country of Residence, Contact_no, DOB, Age
05. Seat
Reference_no, Dimension
06. Airplane
Reg_no, Model_No, Capacity
07. Flight
Flight_No, Departure_airport, destination_airport, Departure_Date&Time, Arrival_Date&Time, Duration
0 Comments