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 ...