Computer Science · May / June 2020 · Paper 21 · Question 6
2210
As printed in the paper
The question as text
A garden centre sells garden tools and stores details of these in a database table named TOOLS. Code is the primary key in the TOOLS table. Code Description Price ($) Quantity_Stock Quantity_Ordered GFLG Garden Fork 50.00 1 50 GSLG Garden Spade 50.00 11 0 GHLG Garden Hoe 45.00 8 0 HFSM Hand Fork 9.99 42 0 HSSM Hand Spade 9.99 40 0 HWSM Hand Weeder 9.99 11 0 HS20 Hose (20 metres) 45.00 10 0 HS35 Hose (35 metres) 60.00 2 0 HS50 Hose (50 metres) 75.00 20 60 YBLG Yard Brush 24.99 100 0 LMHD Lawn Mower 99.99 5 0 LMBT Lawn Mower (Battery) 249.99 7 0 LMPT Lawn Mower (Petrol) 349.99 10 25 TRBT Edge Trimmer (Battery) 79.99 15 0 TRPT Edge Trimmer (Petrol) 59.99 20 0 SHSM Shears 40.00 40 0 HCSM Hedge Clippers 40.00 45 0
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
6(a)[1]
6(b)[3]
6(c)[3]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.