Solution to Exercise 2
Explore the solution to an Entity-Relationship diagram exercise involving airplanes, flights, passengers, and bookings. Understand how to identify primary keys, establish relationships with cardinality, and organize entities to model flight booking data accurately.
We'll cover the following...
We'll cover the following...
Solution
The ER diagram derived from our requirements is shown below.
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 ...