## Contents

### The world table.

Some points to note:

• There is a table called `world` 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: <tbody></tbody>
FieldTypeNullKeyDefaultExtra
namevarchar(50)NOPRInull
continentvarchar(60)YESMULnull
populationdecimal(11,0)YESnull
gdpdecimal(14,0)YESnull
capitalvarchar(60)YESnull
tldvarchar(5)YESnull
flagvarchar(255)YESnull

### 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

## 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.