Flight Modeling

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:

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

Create a data model that allows for the following calculations:

• Determining the shortest path between each hub that passes through non-hub airports.

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

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