| BiologistID | ScientistName | Specialism |
|---|---|---|
| BIO-09 | Dr. Elena Rostova | Abyssal Fauna |
| BIO-14 | Prof. Marcus Vance | Hydrothermal Vents |
| BIO-22 | Dr. Chloe Zhang | Coral Pathogens |
| SubmersibleID | VesselName | DepthRating |
|---|---|---|
| SUB-X2 | Triton-A | 6000m |
| SUB-X5 | Nautilus-IV | 4500m |
| SUB-X9 | DeepVoyager | 11000m |
| DiveID | BiologistID | SubmersibleID | DiveDate |
|---|---|---|---|
| D-8801 | BIO-09 | SUB-X9 | 2024-04-12 |
| D-8802 | BIO-22 | SUB-X2 | 2024-04-15 |
| D-8803 | BIO-09 | SUB-X5 | 2024-04-18 |
State one field in the Dive 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.