A clinical trial registry records patient profiles and clinical trial appointments in a single flat-file spreadsheet.
State one specific reason why migrating to a relational database with linked tables would improve the integrity of the clinical trial data compared to keeping it in the flat-file spreadsheet.
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.