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.
Practise AQA GCSE Computer Science Relational databases with exam-style questions for GCSE Computer Science. 39 questions, matched to the AQA GCSE Computer Science (8525) specification and written in Paper 1 and Paper 2 style. Every question includes a full worked solution and mark scheme, so you can see where marks are awarded rather than just whether you got the answer right.