A marine conservation database stores the radio transmitter frequency of a monitored whale in both the Cetaceans table and the TaggingDeployments table. Explain how this design can lead to data inconsistency if a biologist replaces the whale's transmitter with a new model operating on a different frequency.
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.