This is the table structure of the Cumbrian Miners database in the MS Access data file. Its purpose is to show how relationships work within a relational database. If you look at "Mines" and "Miners" you will see that they are related through a 'bridge' table "Mine_Miners", a miner can work at many mines in his lifetime, and a mine can emply many miners. So its a 'one to many' running both ways
This photograph is by royfellows and was uploaded January 13th 2011. © royfellows please do not copy or distribute without prior express permission.
You can close this window to return to the main site.