| VesselID | VesselName | CaptainName |
|---|---|---|
| V01 | Nautilus | Captain Nemo |
| V02 | Albatross | Captain Ahab |
| V03 | Orca | Captain Quint |
| SpeciesID | CommonName | ConservationStatus |
|---|---|---|
| S301 | Blue Whale | Endangered |
| S302 | Manta Ray | Vulnerable |
| S303 | Great White Shark | Vulnerable |
| SightingID | VesselID | SpeciesID | SightingDate |
|---|---|---|---|
| SG701 | V01 | S301 | 2024-05-12 |
| SG702 | V03 | S303 | 2024-05-13 |
| SG703 | V01 | S302 | 2024-05-15 |
State one field in the Sighting table that acts as 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.