A veterinary clinic database stores a client's mobile phone number in both the Clients table and the Appointments table. Explain how this structure can lead to data inconsistency if the client changes their phone number.
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.