1. Table of COUNTRIES describes countries listing:
COUNTRIES
=========
Country CapitalCity State Continent

2. Table of C_NEIGHBOURS describes neighbouring countries listing:
C_NEIGHBOURS
============
Country Neighbour

3. Table of C_POP_HIST describes population of countries listed in COUNTRIES:
C_POP_HIST
==========
Country Year Population

4. Table of STATES describes states listing in all countries listed in COUNTRIES:
STATES
======
State Country CapitalCity

5. Table of S_S_NEIGHBOURS describes neighbouring states listing in all states listed in STATES:
S_S_NEIGHBOURS 
==============
State Neighbour

6. Table of S_C_NEIGHBOURS describes neighbouring countries listing in all states listed in STATES:
S_C_NEIGHBOURS 
==============
State Neighbour

7. Table of S_POP_HIST describes states with some population history listing:
(Important: This is not true data, it is made up for queries.)
S_POP_HIST
==========
State(or Province) Year Population

8. Table of CITIES describes cities with current population, longitude and latitude listing:
CITIES
======
City State Population Longitude Latitude

9. Table of WATER_BODIES describes water bodies with type (R:River, L:Lake, S:Sea, C:Canal, O:Ocean) listing:
WATER_BODIES
============
WBName Type

10. Table of WB_CITIES describes the cities and the states where the cities reside adjacent to the water bodies:
WB_CITIES
=========
WBName City State

11. Table of WB_COUNTRIES describes the countries adjacent to the water bodies:
WB_COUNTRIES
============
WBName Country

12. Table of WB_STATES describes the states adjacent to the water bodies:
WB_STATES
=========
WBName State

13. Table of WB_CONTINENTS describes the continents adjacent to the water bodies:
WB_CONTINENTS
=============
WBName Continent