Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

image text in transcribed

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 date 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 17AUGO KL 1147 AMSTERDAM OSLO AIRPORT 17AUG N 20K 14 50 AMS OSL 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 INOT VALID AFTER 17AUG 19AUG KL 1142 /STATUS. OK NOT VALID BEFORE 19AUG /NOT VALID AFTER 19AUG A380ort will be required at Checkon. If travel plans ceange, there may be a fee for changing the ticket and iferent tares may apply. Tickets are non-transferable, and are ved if transfered or resold. The e-ticket number will be required for refunds or exchanges Receipt Payment for: 1 Passenger Fare calculations AVSKOSLO KLASINUCIEND ROES 3338T300W 1275015 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 OAIOB on your ticket Surcharges and fees are non refundable

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 Processing

Authors: David M. Kroenke, David Auer

11th Edition

B003Y7CIBU, 978-0132302678

More Books

Students also viewed these Databases questions