e/computer-science/aqa/questions","basePath":"/gcse/computer-science/aqa/relational-databases/questions","formulaUrl":null,"initialIndex":21,"initialQuestionWindow":[{"id":"938cbbdf-e7a9-40fb-aee7-6aed0d465414","revisionId":"8f54404c-ac06-4042-8ab3-68273c4ce9d9","questionNumber":null,"questionType":"LA","specification":"An orbital telemetry database contains a table named `DebrisOrbit` to track individual pieces of space debris in Earth's orbit.","difficulty":3,"difficultyBand":"easy","totalMarks":1,"sourceTitle":null,"calculatorUse":null,"parts":[{"id":"75aa6db2-fb77-4004-ad26-fb14bf32b62a","label":null,"content":"Explain the purpose of a **primary key** in this table.","markscheme":"- States that the primary key is a unique identifier for each record (or row / piece of debris) in the table. B1","marks":1,"order":0,"markingRubric":null,"explanation":null,"options":[]}],"options":[],"explanation":null,"firstAttemptFullMarks":null},{"id":"95a0483d-c24c-428c-9954-30cf7694730e","revisionId":"343cf391-b4a2-4ceb-ba91-a690307c23ce","questionNumber":null,"questionType":"LA","specification":"A clinical trial registry records patient profiles and clinical trial appointments in a single flat-file spreadsheet.","difficulty":4,"difficultyBand":"easy","totalMarks":1,"sourceTitle":null,"calculatorUse":null,"parts":[{"id":"19bede29-fdd8-44bc-b2ad-dc84daae1f29","label":null,"content":"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.","markscheme":"- Explains that it avoids data inconsistency (or update anomalies), as updating a patient's details in one table automatically reflects across all linked appointments, preventing conflicting records B1\n- OR: Explains that it enforces referential integrity, preventing orphan records by ensuring appointments cannot be created for non-existent patients B1\n- OR: Explains that it reduces data redundancy (repeated details), which minimises typing and transcription errors when logging multiple appointments for the same patient B1","marks":1,"order":0,"markingRubric":null,"explanation":null,"options":[]}],"options":[],"explanation":null,"firstAttemptFullMarks":null},{"id":"95f76477-8b1f-4a8a-a7ee-e742417577f7","revisionId":"154e0bfc-7e43-447c-8713-50d4b812e171","questionNumber":null,"questionType":"LA","specification":"### **Pod**\n\n| PodCode | Region | EstimatedSize | FirstRecordedDate |\n| :--- | :--- | :--- | :--- |\n| P-ORC01 | North Pacific | 18 | 2012-05-14 |\n| P-ORC02 | North Atlantic | 9 | 2015-11-03 |\n| P-ORC03 | Southern Ocean | 24 | 2018-02-22 |\n\n### **Sighting**\n\n| SightingID | PodCode | SightingDate | Latitude | Longitude |\n| :--- | :--- | :--- | :--- | :--- |\n| S7001 | P-ORC01 | 2024-03-12 | 48.375 | -123.120 |\n| S7002 | P-ORC03 | 2024-03-15 | -64.210 | -60.450 |\n| S7003 | P-ORC01 | 2024-03-18 | 49.100 | -122.900 |\n| S7004 | P-ORC02 | 2024-03-20 | 64.150 | -21.900 |","difficulty":3,"difficultyBand":"easy","totalMarks":1,"sourceTitle":null,"calculatorUse":null,"parts":[{"id":"6b04255e-f4b2-407a-959a-986810e7dac7","label":null,"content":"State the name of the field from the **Sighting** table that acts as a foreign key.","markscheme":"- Identifies `PodCode` as the foreign key B1","marks":1,"order":0,"markingRubric":null,"explanation":null,"options":[]}],"options":[],"explanation":null,"firstAttemptFullMarks":null}],"subjectCode":"gcse_computer_science__aqa","summaries":[{"id":"11640f60-a059-470e-9688-ad0119408218","difficultyBand":"easy","calculatorUse":null},{"id":"12f7bc61-1203-41dc-81fd-5a0a6501b77c","difficultyBand":"easy","calculatorUse":null},{"id":"2a9ddeef-a265-4576-9737-298e7ca5574a","difficultyBand":"easy","calculatorUse":null},{"id":"2cf6bf96-7e13-4f8c-9f5b-c9127803f014","difficultyBand":"easy","calculatorUse":null},{"id":"4465d9a6-8e7f-41a2-909a-58027e935da8","difficultyBand":"easy","calculatorUse":null},{"id":"5b4b615c-5d04-489a-aefa-dfe32ceb786

Relational databases

Question 22

Relational databases Questions

Relational databases

Question 22

Relational databases Questions