Studierende stehen vor dem LC und blicken lächelnd einer Kollegin mit einer Mappe in der Hand nach.

Exercise No. 23: Airport and Flight Database

Partial Solution 1

a) A flight (Flight-#) consists of one or more flight legs (Flight-Leg-ID), flight legs belong to one flight. Flight legs start at one airport (Code) and end at another airport.

e.g. Flight 405 from Vienna via Frankfurt to London consists of two flight legs (Vienna-Frankfurt and Frankfurt-London).