e/computer-science/aqa/questions","basePath":"/gcse/computer-science/aqa/relational-databases/questions","formulaUrl":null,"initialIndex":32,"initialQuestionWindow":[{"id":"db1e10eb-ac3c-4208-8e7c-29b9ffaa4908","revisionId":"b552c6ac-cf52-4e77-8cac-a7efd8599853","questionNumber":null,"questionType":"LA","specification":"## Beverage\n\n| BeverageID | Name | Category | Price | CustomerRating |\n|---|---|---|---|---|\n| B01 | Espresso | Coffee | 2.50 | 4.65 |\n| B02 | Latte | Coffee | 3.20 | 4.12 |\n| B03 | Green Tea | Tea | 2.80 | 3.80 |\n| B04 | Hot Chocolate | Cocoa | 3.50 | 4.35 |\n| B05 | Chamomile | Tea | 2.90 | 4.05 |\n\n## Transaction\n\n| TransactionID | BeverageID | OrderDate | Quantity | Takeaway |\n|---|---|---|---|---|\n| T101 | B01 | 18/11/23 | 2 | True |\n| T102 | B03 | 18/11/23 | 1 | False |\n| T103 | B04 | 18/11/23 | 1 | True |\n| T104 | B01 | 19/11/23 | 3 | False |\n| T105 | B05 | 19/11/23 | 2 | True |","difficulty":2,"difficultyBand":"easy","totalMarks":1,"sourceTitle":null,"calculatorUse":null,"parts":[{"id":"c4f9e9a0-c272-4e93-8757-65707466d383","label":null,"content":"State the most suitable database data type to use for the **CustomerRating** field.","markscheme":"- States Real, Float, Decimal, or Double B1","marks":1,"order":0,"markingRubric":null,"explanation":null,"options":[]}],"options":[],"explanation":null,"firstAttemptFullMarks":null},{"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}],"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

Relational databases

Question 33

Relational databases Questions

Relational databases

Question 33

Relational databases Questions