Business Rules: Flight Ticket Booking System Only one GUEST per TICKET reservation. However, the same guest can reserve many seat booking. Guest entity has attributes such as GuestID, GuestName, Email, PhoneNo, RegistrationDate, & IC/Passport. Seat entity has attributes such as SeatID, SeatNo, & TypesOfSeatClass. One MANAGER can manages many flight booking. Manager entity has attributes such as ManagerID, ManagerName, Email, & PhoneNo. Book entity has attributes such as BookID, BookName & TimeBooking. One guest can make only one PAYMENT of a seatbooking. Payment entity has attributes such as PaymentID, CreditcardNo, TypesOfPayment & PaymentDate. A payment can has only one BILL. Bill entity has attributes such as BillID, BillDate, SeatCharges.

ER diagram