Note AcademyNote Academy

Computer Science · Oct / Nov 2025 · Paper 23 · Question 8

2210

As printed in the paper

The question as text

A school has set up a database table EquipmentLoan to record details of school equipment loaned to students. EquipmentID Description Name DateLoaned Returned Cam01 Digital camera James 23/04/2025 No Cam04 Digital camera Amir 12/03/2025 Yes Gra02 Graphics tablet Nikita 27/04/2025 No Tab01 Tablet Holly 18/03/2025 Yes Ext01 External Hard drive Hussein 27/04/2025 Yes Cam02 Digital camera Emily 10/04/2025 Yes Tri01 Tripod Emily 10/04/2025 Yes

Read automatically from the paper; the printed page above is exact.

Show the answer and mark scheme
  • 8(a)(i)[1]

  • 8(a)(ii)[1]

    One mark per point, max 1

    Unique field
    No repeating data
  • 8(b)[3]

Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.