Google Code-in

Create 3 tables (1 named “Countries“, 1 named “Touristic places“ and another one named “Points of Interest data“) and insert values into them. Minimum 5 inserts per table (be creative and don't repeat queries). Write 5 SQL Queries using data from the tables. Don't forget to create foreign keys between tables (Countries - Touristic places) and (Touristic places - Points of Interest data).

Imagine we're gonna use these data to create POIs for our applications.

Tables

Table “Countries“ must contain columns (idCountry as PK, name as varchar).

Table “Touristic places“ must contain columns (idTouristicP as PK, idCountry as FK, name as varchar).

Table “Points of Interest data“ must contain columns (idPOI as PK, idTouristicP as FK, latitude as numeric, longitude as numeric, altitude as numeric, range as numeric, heading as numeric, tilt as numeric, altitudeMode as varchar).

Latitude and longitude in decimal!

Label

PK is Primary Key and FK is Foreign Key.

Observation

Simple SQL Queries are not allowed! For example: select * from Countries

Delivery

Send a text file with the queries (tables creation and values inserting included) to our lgcodein@gmail.com address. Publish it too in the selected task of your Google Code-in dashboard for mentor review and approval.