Search⌘ K

Exercise 2

Explore how to design an entity-relationship diagram for a simplified flight database. Understand how to represent entities like airplanes and passengers along with their attributes and relationships to model real-world flight booking scenarios.

We'll cover the following...

The flight database

The flight database stores details about an airline’s fleet, flights, and seat bookings. Again, it’s a hugely simplified version of what a real airline would use, but the principles are the same.

Consider the ...