A marine research station records sightings of migrating whales, including the species name, average lifespan, and geographical coordinates of each sighting, in a single flat-file spreadsheet.
State one reason why migrating this data to a relational database would help prevent inconsistencies in the recorded average lifespan of the whale species.
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.