e/computer-science/aqa/questions","basePath":"/gcse/computer-science/aqa/relational-databases/questions","formulaUrl":null,"initialIndex":20,"initialQuestionWindow":[{"id":"93127d69-f7c3-4d0f-a496-24ed830e95eb","revisionId":"8bfcbd9c-c67c-4b6b-851b-39a5cb241d39","questionNumber":null,"questionType":"LA","specification":"Figure 1 shows two tables from a database used by a gaming archive to track indie game studios and their released titles.\n\n### **Studio**\n\n| StudioID | StudioName | Country | FoundedYear |\n|----------|-----------------|-------------|-------------|\n| S301 | Supergiant | USA | 2009 |\n| S302 | Team Cherry | Australia | 2014 |\n| S303 | Motion Twin | France | 2001 |\n\n### **Game**\n\n| GameID | StudioID | Title | ReleaseYear | Genre |\n|--------|----------|-----------------|-------------|-------------------|\n| G701 | S301 | Bastion | 2011 | Action RPG |\n| G702 | S301 | Hades | 2020 | Roguelike |\n| G703 | S302 | Hollow Knight | 2017 | Metroidvania |\n| G704 | S303 | Dead Cells | 2018 | Roguelike-Metroid |","difficulty":3,"difficultyBand":"easy","totalMarks":2,"sourceTitle":null,"calculatorUse":null,"parts":[{"id":"ca61856e-e103-4c60-af27-e913dfacef91","label":null,"content":"Define the term \"relational database\".","markscheme":"- Explains that data is stored across a collection of separate, distinct tables (or relations) comprising rows and columns B1\n- Explains that these tables are linked or related to one another using common fields (i.e. primary and foreign keys, such as `StudioID` linking both tables) B1","marks":2,"order":0,"markingRubric":null,"explanation":null,"options":[]}],"options":[],"explanation":null,"firstAttemptFullMarks":null},{"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}],"subjectCode

Relational databases

Question 21

Relational databases Questions

Relational databases

Question 21

Relational databases Questions