O-LevelComputer ScienceDatabasesOct/Nov 2022Paper 2 Q78 Marks
A school uses a database table, ASSESS, to keep a record of the internal assessments and the number of candidates for each of the subjects in its curriculum. SubjectCode | SubjectName | Exams | Practicals | Candidates ------------|----------------------|-------|------------|------------ COMP | Computer Science | 2 | 1 | 200 INFO | Information Technology | 1 | 2 | 200 MATH | Mathematics | 3 | 0 | 350 PHYS | Physics | 2 | 1 | 120 CHEM | Chemistry | 2 | 1 | 120 BIOL | Biology | 2 | 1 | 200 GEOG | Geography | 2 | 0 | 200 HIST | History | 2 | 0 | 250 GEOL | Geology | 2 | 0 | 80 PHED | Physical Education | 1 | 2 | 350 FREN | French | 2 | 2 | 120 ENGL | English | 2 | 2 | 350 This database only allows the data types: • text • number • currency • Boolean.
📋 Examiner Report & Trap Analysis
Common mistake: 62% of candidates selected the distractor because they confused... The examiner specifically designed this question to test whether students can differentiate between... To secure full marks, candidates must demonstrate...
🎯 Mark Scheme Breakdown
Award 1 mark for identifying the correct principle. Award 1 mark for showing clear working. Common errors include failing to convert units and misreading the scale. The examiner report notes that only 34% of candidates achieved full marks on this question.
🔒
Unlock the Examiner's Analysis
Sign up for free to reveal the full examiner report, trap analysis, and mark scheme breakdown for this question.
Sign Up Free to Unlock →Join thousands of Cambridge students already using Oracle Prep