You work for an airline company that is updating and further digitizing its flight systems. You’ve been tasked with modeling a subset of the database that keeps track of the following:

<ul>
<li>All airports in the country</li>
<li>Whether the airline flies to each airport</li>
<li>Whether an airport is a hub for the airline</li>
<li>Each airport’s location, including longitude and latitude</li>
</ul>

Create a data model that allows for the following calculations:

<ul>
<li>Determining the shortest path between each hub that passes through non-hub airports.</li>

<li>Potential paths between airports should have a weighting value that represents the fuel demands for that particular path. For example, going from hub A to hub B may pass through airport C with a cost of 50 or airport D with a cost of 70.</li>
</ul>

Note: Recall that a data model includes the names of tables, their columns, primary keys, and foreign key relationships amongst the tables.

Flight Modeling

Comments