| VesselID | VesselName | MaxDepthMeters | CommissionDate |
|---|---|---|---|
| VS01 | Triton | 6000 | 2018-05-14 |
| VS02 | Odyssey | 4500 | 2021-11-02 |
| VS03 | Nautilus | 8000 | 2015-08-22 |
| DiveID | VesselID | DiveDate | LocationCode |
|---|---|---|---|
| DV801 | VS01 | 2024-02-12 | MAR-01 |
| DV802 | VS03 | 2024-02-15 | TON-04 |
| DV803 | VS01 | 2024-02-18 | MAR-02 |
| DV804 | VS02 | 2024-02-20 | PER-09 |
State the name of the field from the DiveLog table that is a foreign key.
38 exam-style questions on AQA GCSE Computer Science Relational databases. Each one has a worked solution and a mark scheme showing where the marks go.