O-LevelComputer ScienceDatabasesOct/Nov 2024Paper 2 Q117 Marks
Building materials are sold in bags. A new database table called BuildStock has been set up to store details about the materials for sale. Part of this table is given. MtNo Name InStock WeightKg PricePerBag NumberBags MT01 Builders sand Yes 50 4.50 50 MT02 Sharp sand Yes 25 3.50 21 MT03 Red sand No 50 2.75 0 MT04 Cement No 25 6.85 0 MT05 Chippings Yes 50 35.00 50 MT06 Cobbles No 75 67.35 0 MT07 Pebbles small Yes 50 34.50 3 MT08 Pebbles medium Yes 25 25.50 10 MT12 Pebbles large Yes 75 62.75 20 MT15 Washed gravel Yes 50 12.75 12 MT16 Pea gravel Yes 100 15.95 24
📋 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