![Airport city code list](https://kumkoniak.com/24.jpg)
![airport city code list airport city code list](https://www.ccra.com/wp-content/uploads/2017/11/airport-codes.jpg)
![airport city code list airport city code list](https://1.bp.blogspot.com/-4ny_A3CSNao/XbX7eekZgLI/AAAAAAAAD7U/0naTiKHcZrkMIYn_7Y6F11OsK7k-jd7DwCLcBGAsYHQ/s1600/1.jpg)
The airport is located about 12 km south of downtown Manila, between the cities of Pasay and Parañaque.Īs a main point of entry for most travelers, NAIA airport has regular flights by the biggest carriers like Philippines Airlines and Cebu Pacific, as well as low-cost airlines like Philippines AirAsia. Manila International Airport or informally known as NAIA Airport, is the largest of all airports in the Philippines. International & major domestic airports Manila Ninoy Aquino Airport – IATA Code – MNL Map of airports in the Philippines can be found at the bottom of the text. We’ll summarize the most important ones, so you can see which airport to fly into when visiting the Philippines. Due to more and more travelers exploring the country’s numerous islands, airline traffic keeps increasing each year.Ĭurrently, there are over 70 Philippines airports handling international, domestic, and charter flights. If a query uses PK or FK values explicitly where it shouldn't, the answer will be invalidated.The Philippines are an island country in Southeast Asia, heavily influenced by both Anglo-European and Asian culture. Therefore, you must not use any primary key values explicitly, unless otherwise mentioned. Primary keys are used to uniquely identify tuples and also to 'link' tables with their corresponding foreign keys. If a question explicitly uses a PK value, e.g., "Where is the airport 'YYZ' located?", then you can use it in a selection like ocode='YYZ' or like in where code='YYZ'. For example, you can use 'Toronto' in a selection, not 'YYZ'.
![airport city code list airport city code list](https://image.slidesharecdn.com/internationalairportcodesiata3-180226062544/95/international-airport-codes-iata-3-35-638.jpg)
![airport city code list airport city code list](https://www.world-airport-codes.com/content/uploads/2014/01/World-Airport-Codes-2003.png)
You must assume you don't know airport codes, but only city names, unless otherwise mentioned in the question. In this database we have 5 relations (tables). This is a simplified flight booking database. Transcribed image text: Consider the relational schema below and write relational algebra queries for the next questions.
![Airport city code list](https://kumkoniak.com/24.jpg)