Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 reservations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

9th Edition

0135188148, 978-0135188149, 9781642087611

More Books

Students also viewed these Databases questions