Solution to Exercise 2

Solution to exercise 2.

We'll cover the following...

Solution

The ER diagram derived from our requirements is shown below.

Press + to interact

Explanation

In our design:

  • An AIRPLANE is uniquely identified by its Registration_Num, so we use this as the primary key.

  • A FLIGHT is uniquely ...