To be able to show only those hotels that are located at the airport through which the traveler is transiting, we need to model airports. Currently, airports are a part of the flight information, and this needs to change. We will extract airport information (that is, airport_code) into a separate node labeled :Airport, as shown in Figure 5.1. The property code will act as a unique identifier for an airport.

Figure 5.1: Airports and hotels

Hotels will be modeled with their name and the price. Since prices should be comparable, storing them as a number would be beneficial. Considering hotel chains have similar or same names for each class of hotel that that they own, it would be good to have an ID on the hotels.