O-LevelComputer ScienceDatabases2210/23 · Oct/Nov 2025 · Q85 Marks
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
- (a)(i)Give the name of the field that is most appropriate to be the primary key.[1]
- (a)(ii)State the reason for choosing this field for the primary key.[1]
- (b)Complete the structured query language (SQL) statement to list equipment not returned. The list must contain only the descriptions and student names. SELECT FROM WHERE[3]
Mark scheme
Marking points from the official mark scheme (Oct/Nov 2025). The mark or mark type is shown in brackets.
- [1] (a)(i) EquipmentID
- [1] (a)(ii) Unique field
- [1] (a)(ii) No repeating data
- [1] (b) SELECT Description, Name
- [1] (b) FROM EquipmentLoan
- [1] (b) WHERE Returned = "No";
Write your answer and get it marked
On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.
Sign up free →