plumiDatabases and distributed systems: Eduqas A‑Level Computer Science questions
Every Eduqas A-Level Computer Science exam question on 2.5 Databases and distributed systems, 2016–2025, with its mark scheme and examiner’s report.
Paper
All papers
Exam
All years
Calculations
Q7(a)(i)
The whole paper ↗
Q7(a)(ii)
The whole paper ↗Q8(a)
The whole paper ↗
Q8(b)
The whole paper ↗Q8(c)
The whole paper ↗Q8(d)
The whole paper ↗Q11(b)
The whole paper ↗
Q4(a)
The whole paper ↗
Q4(b)(i)
The whole paper ↗Q4(b)(ii)
The whole paper ↗Q4(b)(iii)
The whole paper ↗Q5(a)
The whole paper ↗
Q5(b)
The whole paper ↗Q5(c)
The whole paper ↗Q5(d)
The whole paper ↗Q5(e)
The whole paper ↗
All 81 questions on Databases and distributed systems, as a list
- June 2025, Component 2, Q7(a)(i) (4 marks): Draw an entity-relationship diagram of a suitable database structure. [4]
- June 2025, Component 2, Q7(a)(ii) (4 marks): Design a database for this situation. [4]
- June 2025, Component 2, Q8(a) (2 marks): Write an SQL command to output the projectID and startDate for all projects allocated to teamNo 01. [2]
- June 2025, Component 2, Q8(b) (3 marks): Write an SQL command to list the tradingName and category only for all eCommerce projects that have not been archived. [3]
- June 2025, Component 2, Q8(c) (2 marks): An extra record is to be entered into the PROJECT table for Craft House DIY. It is to be a design only service, allocated to teamNo 20 with projectID 07200. The
- June 2025, Component 2, Q8(d) (3 marks): An additional table is required to record details of the project teams. The required fields, with examples of records, are shown. Each team will have a team lea
- June 2025, Component 2, Q11(b) (4 marks): Explain the term ‘data warehouse’. [4]
- June 2025, AS Component 1, Q8 (5 marks): Consider a library system. Each copy of a book has a unique ID, a title and a genre. Each author is identified by a unique ID and has a name. Each book is writt
- June 2025, AS Component 2, Q1 (8 marks): Draw a data structure table that will allow PVLP to store its customers’ details. [8]
- June 2024, Component 2, Q4(a) (2 marks): Identify two aspects of the design likely to cause problems when searching or sorting the table. [2]
- June 2024, Component 2, Q4(b)(i) (3 marks): Produce an entity-relationship diagram to show the relational links between the proposed tables. [3]
- June 2024, Component 2, Q4(b)(ii) (4 marks): Assume members individually book the courts and that the duration of all timeslots is the same. Design a database in third normal form for the booking system. [
- June 2024, Component 2, Q4(b)(iii) (3 marks): Suggest measures that could be incorporated in the database to prevent double bookings. [3]
- June 2024, Component 2, Q5(a) (1 mark): Write an SQL command to output the CheckNo and Comment only for all of the checks. [1]
- June 2024, Component 2, Q5(b) (1 mark): Write an SQL command to output the RegNo for all checks allocated to StaffID MS. [1]
- June 2024, Component 2, Q5(c) (2 marks): Write an SQL command to reallocate CheckNo 67 to StaffID JO. [2]
- June 2024, Component 2, Q5(d) (2 marks): Write an SQL command to output the Date and StaffID for all checks allocated to Veer Patel. [2]
- June 2024, Component 2, Q5(e) (4 marks): Write an SQL command to create a new table E_VANS to contain the Make, Registration Number and ChargeTime (hrs, mins : 0,00) for each of the new electronic vehi
- June 2024, Component 2, Q7 (6 marks): Explain what is meant by distributed processing, giving an example to illustrate its operation. [6]
- June 2024, AS Component 2, Q1 (8 marks): Draw a data structure table that will allow PVCC to store and validate customer details. [8]
- June 2023, Component 2, Q2(a) (4 marks): Explain the predictive analytics service provided by Pre_insight.co.uk [4]
- June 2023, Component 2, Q2(b) (2 marks): Identify two sources of unstructured data that Pre_insight.co.uk could use to provide this service. [2]
- June 2023, Component 2, Q3(a) (6 marks): Explain what is meant by data redundancy, data consistency and data independence. [6]
- June 2023, Component 2, Q3(b)(i) (3 marks): Produce an entity relationship diagram for the booking system described. [3]
- June 2023, Component 2, Q3(b)(ii) (4 marks): Design a database structure in third normal form for the booking system. [4]
- June 2023, Component 2, Q7(a) (4 marks): Write an SQL command that will create the table using appropriate data types and sizes. [4]
- June 2023, Component 2, Q7(b)(i) (1 mark): Write an SQL command to insert this record into the Booking table: [1] BK00012 Ms P Evans 6 HK05 09/09/2023 6575.00
- June 2023, Component 2, Q7(b)(ii) (1 mark): Write an SQL command to change the cost of a night at the Blue Horizon to £275.50. [1]
- June 2023, Component 2, Q7(b)(iii) (2 marks): Write an SQL command to output the destination code and email address of each destination in alphabetical order. [2]
- June 2023, Component 2, Q7(b)(iv) (2 marks): Write an SQL command to output the bookingNo and customerName of all customers with bookings in July with 4 or more passengers. [2]
- June 2023, AS Component 2, Q1 (8 marks): SpringZone would like to create an entity relationship diagram for the main relationships in the system. Referring to the scenario, create an entity relationshi
- June 2023, AS Component 2, Q2 (5 marks): SpringZone has decided to store adults’ details in a database table. Referring to the scenario, copy and complete the following data structure table. [5] Key fi
- June 2022, Component 2, Q4(a) (4 marks): AP Translation Limited (APT) provides professional language translation and interpretation services, specialising in legal and technical translations. The compa
- June 2022, Component 2, Q4(b)(i) (3 marks): Produce an entity relationship diagram for the job system described. [3]
- June 2022, Component 2, Q4(b)(ii) (4 marks): Design a database structure in third normal form for the job system. [4]
- June 2022, Component 2, Q5(a) (4 marks): The following describes a database table: Booking (bookingID, holidayID, bookingDate, holidayDate, customerID, cost) Write an SQL command that will create this
- June 2022, Component 2, Q5(b)(i) (2 marks): Write an SQL command to output the destinationName and hotelName of all the holidays in ascending order of country. [2]
- June 2022, Component 2, Q5(b)(ii) (2 marks): Write an SQL command to output the bookingID and customerID of holidays taking place in July. [2]
- June 2022, Component 2, Q5(b)(iii) (2 marks): A new customer, C2001, has made a booking for S198. The booking was made on 27/02/2022 with the holiday taking place on 23/06/2022. The cost of the holiday is £
- June 2022, AS Component 2, Q1(a) (5 marks): Create an entity relationship diagram for PP as described in the scenario. There is no need to include any attributes. [5]
- June 2022, AS Component 2, Q1(b) (10 marks): Create a data structure table for one of the tables stated in your entity relationship diagram. [10]
- Autumn 2021, Component 2, Q2(a) (3 marks): Produce an entity relationship diagram for the booking system described. [3]
- Autumn 2021, Component 2, Q2(b) (4 marks): Design a database structure in third normal form for the booking system. [4]
- Autumn 2021, Component 2, Q2(c) (2 marks): Describe an advantage of structuring data in third normal form. [2]
- Autumn 2021, Component 2, Q4(a) (4 marks): Write an SQL command that will create this table using appropriate data types and sizes. [4]
- Autumn 2021, Component 2, Q4(b)(i) (2 marks): Write an SQL command to output the schoolName and telephoneNo of all the schools in ascending order of postcode. [2]
- Autumn 2021, Component 2, Q4(b)(ii) (2 marks): Write an SQL command to output the bookingNo and schoolCode of schools with bookings in April with 7 or more delegates. [2]
- Autumn 2021, Component 2, Q4(b)(iii) (2 marks): Write an SQL command to output the schoolCode and postCode of schools with a trainingDate before 20/04/2022. [2]
- Autumn 2021, Component 2, Q6 (6 marks): Explain the terms data mining and predictive analytics. [6]
- Autumn 2020, Component 2, Q2(a) (4 marks): Produce an entity-relationship diagram for the theatre booking database in third normal form. [4]
- Autumn 2020, Component 2, Q2(b) (4 marks): Design a structure for the theatre booking database clearly identifying all primary and foreign key fields required. [4]
- Autumn 2020, Component 2, Q4(a) (2 marks): Write an SQL command to output the Name and Address only for all Senior members. [2]
- Autumn 2020, Component 2, Q4(b) (2 marks): Write an SQL command to output the MemberID of all members who have completed the course in less than 17 minutes. [2]
- Autumn 2020, Component 2, Q4(c) (2 marks): Write an SQL command to output the Name for all members who trained on 15 April 2020. [2]
- Autumn 2020, Component 2, Q4(d) (2 marks): Write an SQL command to record that, on 15 April 2020, member 106 recorded a time of 17 minutes 20 seconds. [2]
- Autumn 2020, Component 2, Q4(e) (2 marks): Another table is required to record data for membership fees. Write an SQL command to create a new table Payment to contain the following fields: [2] Field nam
- Autumn 2020, Component 2, Q12 (9 marks): Explain, giving an example of each, what is meant by the concepts of Big Data, data mining and predictive analytics. [9]
- Autumn 2020, AS Component 2, Q1(a) (8 marks): Met would like to create an entity relationship diagram for the main relationships in the system. Referring to the scenario create an entity relationship diagra
- Autumn 2020, AS Component 2, Q1(b) (4 marks): Met has decided to store tenant details in a database table. Referring to the original scenario copy and complete the following data structure table. [4] Key f
- June 2019, Component 2, Q9(a) (2 marks): Write an SQL command to list the Species and YearPlanted only for each FOREST_BLOCK record. [2]
- June 2019, Component 2, Q9(b) (3 marks): Write an SQL command to list the ActivityDescription and StartDate only for all activities taking place at the Location ‘Little Sutton’. [3] An additional table
- June 2019, Component 2, Q9(c) (3 marks): Write an SQL command to create this table using suitable data types. [3]
- June 2019, Component 2, Q9(d) (2 marks): Extra records are to be entered into the WORKER table as shown above: Michael Smith is allocated WorkerID 5221. He is not qualified to drive a tractor. Gurvinde
- June 2019, Component 2, Q10(a) (3 marks): Draw an entity-relationship diagram in third-normal form to illustrate the scenario described above. [3]
- June 2019, Component 2, Q10(b) (5 marks): Produce a design for the database, clearly indicating the fields which link the tables. [5]
- June 2019, AS Component 1, Q4(a)(i) (3 marks): Describe the features of this type of database structure. [3]
- June 2019, AS Component 1, Q4(a)(ii) (4 marks): Describe the benefits and drawbacks of this type of database structure. [4]
- June 2019, AS Component 1, Q4(b) (2 marks): Using an example from the structure on page 5, give one advantage of different users having different views of the data in this database. [2] Advantage
- June 2018, Component 2, Q1(a) (2 marks): Write an SQL command to list the ArrivalDate and ShipName for each VOYAGE record. [2]
- June 2018, Component 2, Q1(b) (3 marks): Write an SQL command to list the ContainerID and Contents for all containers on voyages ArrivingFrom ‘Shanghai’. [3] An additional table is required to record t
- June 2018, Component 2, Q1(c) (3 marks): Write an SQL command to create this table using suitable data types. [3]
- June 2018, Component 2, Q3(a) (2 marks): Explain why the database is not in third normal form. [2]
- June 2018, Component 2, Q3(b)(i) (4 marks): Draw an entity-relationship diagram for the revised database structure. [4]
- June 2018, Component 2, Q3(b)(ii) (5 marks): Design a database for this situation. [5]
- June 2017, Component 2, Q1(a) (4 marks): Write an SQL command that will create this table using appropriate data types and sizes. [4]
- June 2017, Component 2, Q1(b)(i) (2 marks): Write an SQL command to output the names and phone numbers of all the customers in ascending order of customerPostcode. [2]
- June 2017, Component 2, Q1(b)(ii) (2 marks): Write an SQL command to output the names and phone numbers of customers with an orderDate before 01/03/2016. [2]
- June 2017, Component 2, Q1(b)(iii) (2 marks): Write an SQL command to output all the orders in descending order of handlingCost for customerNo 27. [2]
- June 2017, Component 2, Q7(a) (4 marks): Explain what is meant by database normalisation. [4]
- June 2017, Component 2, Q7(b) (3 marks): A school’s pupils have lessons in various subjects with each pupil studying more than one subject. A subject can be taught in different rooms and by different t
- June 2017, AS Component 2, Q2 (5 marks): Marble Garden Centre has decided to store customer details in a database table. Copy and complete the following data structure table. [5] Keyfield Possible Fiel
Questions, mark schemes and examiner’s reports are © WJEC Eduqas, from their published past papers. Plumi isn’t affiliated with any exam board. Want whole papers? Full past papers.
Rather write your answers by hand on iPad? Plumi marks them against the same mark schemes.