A Gentle Introduction to

SQL


Pick an engine:

Congestion Charging database

Graduated questions (these questions were used session 2002-2003)

ER diagram for the Congestion Charging database:

Entity relation diagram er5 camera(id, perim)

keeper(id, name, address)

vehicle(id, keeper)

image(camera, whn, reg)

permit(reg, sDate, lDate, chargeType)

SQL Source to create the database,

SQL Source to populate the tables.

Sample query

0a
List the vehicles for which 'Strenuous, Sam' is the registered keeper.
The link between keepers and vehicles is via the foreign key specified in the CREATE TABLE Vehicle statement. Note the line 
 ,FOREIGN KEY(keeper) REFERENCES keeper(id)
This will be the basis of our join condition.