e/computer-science/aqa/questions","basePath":"/gcse/computer-science/aqa/relational-databases/questions","formulaUrl":null,"initialIndex":34,"initialQuestionWindow":[{"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},{"id":"e2573f39-83b9-4901-93eb-2375ed209f2d","revisionId":"e7b63fc5-0f42-4c5d-8790-c06ec64ebabf","questionNumber":null,"questionType":"LA","specification":"","difficulty":4,"difficultyBand":"easy","totalMarks":2,"sourceTitle":null,"calculatorUse":null,"parts":[{"id":"1b590311-9177-4dd0-9bc0-f836f3f4cc39","label":null,"content":"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.","markscheme":"- Explains that the billing address might be updated in one table (such as `Subscribers`) but not in the other (`Invoices`), or the change is missed in one of the tables M1\n- Explains that this leads to conflicting or mismatched address records for the same subscriber, rendering the database state inconsistent and unreliable A1","marks":2,"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-dfe32ceb7868","difficultyBand":"easy","calculatorUse":null},{"id":"5e90f8cd-1d63-4b7a-acd3-d5ab982031f0","difficultyBand":"easy","calculatorUse":null},{"id":"60e58a4b

Relational databases

Question 35

Figure 1

Spacecraft

CrewAssignment

Astronaut

Relational databases Questions

Relational databases

Question 35

Figure 1

Spacecraft

CrewAssignment

Astronaut

Relational databases Questions