An online streaming platform stores a subscriber's billing address in both the Subscribers table and the Invoices table. Explain how this relational design can lead to data inconsistency if a subscriber moves to a new address.
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.