## BBC Country Profiles.

Some points to note:

• There is a table called `bbc` with nearly 200 records.
• The first record is `Afghanistan` in `Asia`
• The final record is `Zimbabwe` in `Africa`.
• The table has five columns or `attributes` . These are:
• `name`
• `region`
• `area`
• `population`
• `gdp`

## An extract from the table `bbc`

name region area population gdp
Yemen Middle East 536869 21500000 12255000000
Zambia Africa 752614 11000000 4950000000
Zimbabwe Africa 390759 12900000 6192000000

## Footnotes

### Per Capita GDP

The per capita GDP is the GDP divided by the population. It is a rough measure of the average salary. A rich country is one with a high per capita GDP.

### Original source

This data has been collected from the BBC country profiles - it may be a little out of date. The latest version can be found at http://news.bbc.co.uk/1/hi/world/default.stm . Some changes have been made to the data - the reader should assume that errors and omissions are due to me and not the peerless BBC.

### Area

The area is measured in square kilometers.

### GDP

I have taken the liberty of multiplying the GNI per capita (as published by the BBC) by the population. I am pretty sure that this is not correct but these tutorials are about databases not about economics.

### Scientific Notation

Some implementations of SQL may show large numbers in scientific notation. The number 6.23 E9 means 6.23 x 10 9 which is 6.23 x 1,000,000,000 which is 6,230,000,000
A Million is 10 6 which is 1,000,000
A Billion is 10 9 which is one thousand million which is 1,000,000,000
A Trillion is 10 12 , which is one million million which is 1,000,000,000,000.