It is required to design a database for booking airline tickets using Microsoft Excel with clarification of tables and design

The e-Ticket of Airline shown in figure Design the database of the e-Ticket system, suggest data and type of each filed, and assign to primary key and key in the database KLM e-ticket Booking code 8V32EU E-ticket issue dater 2AUG Issued by: KLM EBT NETHERLANDS Thank you for choosing KLM E ticket This is the trip summary for FREEKMR VANDENBROEK If unable to use the e-ticket if travel plans change or if you received this document in error please call KLM at +31 900 359556 WEB Passenger Information Passenger name FREEKMR VANDENBROEN E-ticket number 074 2464639523 Number loyalty program itinerary information Date Flight Departing Arriving Date Class Baggage 17AUG KL 1147 AMSTERDAM OSLO AIRPORT 17AUG N 20K 14 50 AMS OSI 16 35 19AUG KL 1142/OSLO AIRPORT AMSTERDAM 19AUG N 20K 09:40 OSL AMS 11 30 17AUG KL 1147 STATUS OK INOT VALID BEFORE 17AUG/NOT VALID AFTER 17AUG 19AUG KL 1142 /STATUS OK NOT VALID BEFORE 19AUG/NOT VALID AFTER 19AUG A380ort will be required ar Crecen. I travel plans ceange, there may be a fee for changing the ticket and iferent tares may apply. Tickets are non-transferable, and are void if transfered or resold. The e-ticket number we recured for refunds or exchanges Receipt Payment for 1 Passenger Fare calculations ALS OSLO KLASINUCIS END ROES 333T3 DOW1273015 AZN 190008 Fare amount: EUR 99.00 Tax/Fees/Charges EUR 46.00YR 13 22RN 38.46XT Total amount: EUR 196.68 Method of payment: MISC Restrictions: NONENDO/NONREFINONREROUTE Surcharges and/or fees collected are shown as tax code OA OB on your ticket Surcharges and fees are non refundable