Assignment You have been consulted to build a web-based ticketing booking system for Passion Air a domestic airline in Ghana that has Kotoka International Airport as its main hub in Accra. Founded as DAC International Airlines (Ghana) by Edward Annan a notable local businessman in partnership with DAC Aviation of Kenya. Passion Air was founded in 2017 and attained its Air Operator Certificate in December the same year. Passion Air commenced its flight operations under the Passion Air brand in August 2018 using one Bombardier Dash 8 Q400 and operates to the following destinations; Kumasi, Tamale, and Takoradi from the Kotoka International Airport in Accra. Till date Passion Air is the second largest airline in Ghana and have transported over 200,000 passengers. Passion Air's ticket booking system will allow prospective passengers to search for available flights for either of the destinations on a certain date. After the user finds and select the flight needed, he or she can book a ticket. Users who are registered on the system can book a ticket, and they have the option to provide authentication details while booking the ticket, or if not registered users can register with the application. Assignment On the Passion Air's ticket booking system a user can book only a single one-way ticket to any of the destinations specified. The ticket will not have an arrival date or arrival time displayed. More so, though the user's credit card details will be captured, these will not be used to produce any billing information. As the consultant you are required to design an Entity-Relationship (E-R) diagram for the Passion Air ticket booking system. In your E-R diagram clearly identify entities, attributes, relationship and constraints involved. Which DBMS architecture would you choose per the design of the system and why would the other architectures not be a good choice? . Due date: 16th March, 2021 @ 8:15am