Relationships

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 13^th 2011. © royfellows please do not copy or distribute without prior express permission.

Rating

Nobody has rated this photograph yet, why not be the first?

Copy & Paste Forum Code

To display this photograph in a forum message please copy the text below and paste it into your forum message:

[photo]58024[/photo]

To display this photograph in a forum message and link to the full size image please copy the text below and paste it into your forum message:

[link]58024[linkphoto]58024[/linkphoto][/link]