e/computer-science/aqa/questions","basePath":"/gcse/computer-science/aqa/relational-databases/questions","formulaUrl":null,"initialIndex":33,"initialQuestionWindow":[{"id":"dcfdba44-98f0-4261-bba0-73d53eb71e45","revisionId":"fd85a04d-d192-4265-af74-45b63df61ad3","questionNumber":null,"questionType":"LA","specification":"A marine research station records sightings of migrating whales, including the species name, average lifespan, and geographical coordinates of each sighting, in a single flat-file spreadsheet.","difficulty":4,"difficultyBand":"easy","totalMarks":1,"sourceTitle":null,"calculatorUse":null,"parts":[{"id":"39e09040-2181-4e36-a963-37f4dbd3cf83","label":null,"content":"State **one** reason why migrating this data to a relational database would help prevent inconsistencies in the recorded average lifespan of the whale species.","markscheme":"- The average lifespan for each species is stored only once (e.g. in a separate `Species` table) rather than being duplicated across multiple sighting records, eliminating data redundancy. B1\n- Any update or correction to a species' average lifespan only needs to be made in a single record rather than multiple times across different sightings, preventing conflicting/inconsistent data. B1","marks":1,"order":0,"markingRubric":null,"explanation":null,"options":[]}],"options":[],"explanation":null,"firstAttemptFullMarks":null},{"id":"ddaa89d5-cca4-4b97-b43c-7ec9f7908784","revisionId":"326e2b6f-e3c2-4f13-9101-2601bb6ac09c","questionNumber":null,"questionType":"LA","specification":"","difficulty":4,"difficultyBand":"easy","totalMarks":2,"sourceTitle":null,"calculatorUse":null,"parts":[{"id":"ed524d9b-ce88-407d-9d69-a3a18718fa48","label":null,"content":"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.","markscheme":"- Explains that the change might be updated in one table but missed, forgotten, or not updated in the other table B1\n- Explains that this results in conflicting, different, or mismatched versions of the same client's phone number in the database B1","marks":2,"order":0,"markingRubric":null,"explanation":null,"options":[]}],"options":[],"explanation":null,"firstAttemptFullMarks":null},{"id":"ddaddee1-8d8a-4ccf-baef-d6405f0145fd","revisionId":"148a1e4b-a1c4-47ff-bc10-1bffe15dff29","questionNumber":null,"questionType":"LA","specification":"### Figure 1\n\n### Spacecraft\n\n| CraftID | Model | PayloadCapacity |\n| :--- | :--- | :--- |\n| SC-101 | Orion | 8500 |\n| SC-102 | Dragon | 6000 |\n| SC-103 | Soyuz | 2500 |\n\n### CrewAssignment\n\n| AssignmentID | CraftID | AstronautID |\n| :--- | :--- | :--- |\n| A801 | SC-101 | AST-22 |\n| A802 | SC-102 | AST-45 |\n| A803 | SC-103 | AST-19 |\n\n### Astronaut\n\n| AstronautID | Surname | SpaceAgency |\n| :--- | :--- | :--- |\n| AST-19 | Kononenko | Roscosmos |\n| AST-22 | Hansen | CSA |\n| AST-45 | Glover | NASA |","difficulty":2,"difficultyBand":"easy","totalMarks":1,"sourceTitle":null,"calculatorUse":null,"parts":[{"id":"c40ea8b6-8a95-484b-86da-0d1ee7760a04","label":null,"content":"State the identifier of a field from the **Astronaut** table in Figure 1.","markscheme":"- Any one of: `AstronautID`, `Surname`, or `SpaceAgency` 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

Relational databases

Question 34

Relational databases Questions

Relational databases

Question 34

Relational databases Questions