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

Transfer the following verbal description into an ERM

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.

b) Flight legs are parts of a daily flight leg combination (DFLeg-ID). A daily flight leg combination is assigned to one aircraft type (Type ID) and an aircraft type is assigned to one daily flight leg combination.

c) An aircraft type can land at several airports.

Solution (Part 1)

Exercise List