Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please i NEED HELP. Please provide me the ER-diagram with attributes for the above case. Flight Reservation System Case study: A typical flight reservation system
Please i NEED HELP.
Please provide me the ER-diagram with attributes for the above case.
Flight Reservation System Case study: A typical flight reservation system asks information from the customers about origin, destination, passengers, flight dates and travel document identity. Some of the vital details include: name, gender age, address, passport number, the type of plane the customer would like to travel in and the customers destination point. The most important part of any reservation system is its search functionality in able to find out several direct and indirect flight options for a client according to the given parameters. During the search phase, additional information may also be presented to the customer such as the lowest fare on a particular date, number of available seats at the point of search System also displays the unavailability of seats meeting the desired criteria. Cancellation of reserved seat and any permissible changes in the reservation should also be part of reservation system. Flight reservation system is efficient enough to re-track the number of available seat as soon as a cancellation is made. The flight reservation system possesses the capacity to print tickets with all the details such as flight details, passenger data, the class, name of the plane, in addition to destination Price list of various tickets is also included in the system. Customers can use the Search engine in the system in order to find suitable flight for them. They interact with the system by filling the search. Customers can choose any ticket from flight calendar. In the flight calendar, customers can view all available flights. Both customers and admin can insert their personal details in the system. order to interact with the system, customers can add their information in the system. The system supports purchasing process. Customers can make payment in order to book a flight. They can insert their card. details and confirm the payment. Also they receive the booking reference code after they make the payment successfully. Customers can print E-ticket. When customers finish the booking process, they receive their ticket directly. Also they can print the ticket. Customers can therefore make use of this system to make reservations, modify reservations in addition to cancel reservationsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started