Generate plain HTML

Airline Assignment

Sample Data

These are the tables we will use as an example:

SELECT * FROM Customers
Customer# CustomerName CreditCard# Country
654321Frank Reynolds4567890123456789USA
765432Derek Smalls3456789012345678UK
876543David St Hubbins2345678901234567UK
987654Nigel Tuffnel1234567890123456UK 
SELECT * FROM Pilots
PilotName License#
Charlie Kelly456789
Dennis Reynolds234567
Ronald MacDonald345678 
SELECT * FROM Planes
Plane# PlaneName PilotName
424242Enola GayDennis Reynolds
676767Hawker HoopoeCharlie Kelly
818181Wright FlyerRonald MacDonald 
SELECT * FROM Tickets
Customer# Plane# Seat#
765432818181200
8765434242423
8765436767673
9876544242422
9876546767672