Modeling airports and hotels
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.
Note
The currency in which the price is expressed should be a application concern and should not be spread across data and application. Ideally, a standard currency (for example, USD or EUR) would be used to express the price, and the conversion to local currency...
