Databases — AS & A Level Computer Science (9618) questions by topic
Describing how a relational database overcomes the limitations of a file-based approach, writing queries against tables such as CUSTOMER and FURNITURE, and stating what a data dictionary contains sit at the centre of this topic, worth between 11 and 19 marks across 13 real questions from 2023 to 2025 papers.
Write, identify, state, explain and describe are the leading command words, and write typically means a correct SQL statement referencing the exact fields and tables given in the scenario. Because a single wrong table or field name breaks an otherwise sound query, drafting the statement and checking it against instant marking quickly confirms the syntax and references both hold up.
May–June 2025, Paper 11
A company builds and sells furniture to customers. The company stores data about customers, their payment cards and their furniture orders in a database. The database, FURNITURE,…
Answer this question and get it marked →May–June 2025, Paper 12
An online game has a database that stores data about users and the characters each user creates in the game. Each user can create multiple characters and purchase multiple items…
Answer this question and get it marked →May–June 2025, Paper 13
A shop sells pens to customers. Customers place an order with the shop and collect the items the next day. The shop uses a database to store the information about the orders. The…
Answer this question and get it marked →May–June 2024, Paper 12
Identify the relationship between EXAM and EXAMQUESTION.
Answer this question and get it marked →May–June 2024, Paper 13
Identify the relationship between the tables PERFORMANCE and SHOW.
Answer this question and get it marked →October–November 2024, Paper 11
A shop repairs electronic devices, for example mobile phones and tablet computers. The shop owner stores the data about the repairs using a file-based approach. Give one…
Answer this question and get it marked →October–November 2024, Paper 12
A company uses a relational database to store data about its customers, employees and the individual repair jobs that customers have booked. Explain the benefits of using a…
Answer this question and get it marked →October–November 2024, Paper 13
Identify two foreign keys in the table SALE and the table that each foreign key references. Foreign key 1 ... Table name 1 ... Foreign key 2 ... Table name 2 ...
Answer this question and get it marked →May–June 2023, Paper 11
The database is managed using a Database Management System (DBMS). State what is meant by a data dictionary and give one example of an item typically found in a data dictionary.…
Answer this question and get it marked →May–June 2023, Paper 12
The table contains names and descriptions of DBMS features and tools. Complete the table by writing down the missing names and descriptions. Name Description --- --- Data…
Answer this question and get it marked →May–June 2023, Paper 13
A shop rents cars to customers. The shop uses a relational database to store information about the rentals. Describe two ways in which a relational database addresses the…
Answer this question and get it marked →October–November 2023, Paper 11
A shop manager has designed a relational database to store customer orders. The database will have the following tables (primary keys are underlined in the question paper):…
Answer this question and get it marked →October–November 2023, Paper 12
State what is meant by the following terms in a relational database model. Entity ........................................................................... Primary key…
Answer this question and get it marked →Other AS & A Level Computer Science topics
- Programming (79)
- Data types and structures (74)
- Algorithm design and problem-solving (36)
- Information representation (31)
- Communication and internet technologies (29)
- Boolean algebra and logic circuits (29)
- Processor fundamentals (27)
- Software development (27)
- Hardware (18)
- System software (17)
- Security, privacy and integrity of data (13)
- Artificial intelligence (13)