Computer Science · May / June 2020 · Paper 21 · Question 6
0478
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]
To uniquely identify a product (in TOOLS)
6(b)[3]
HS50
Hose (50 metres)
60
GFLG
Garden Fork
50
LMPT
Lawn Mower (Petrol)
25
One mark for correct data
One mark for correct format
One mark for data in correct order
6(c)[3]
Field: Code
Description
Quantity_Stock
Table: TOOLS
TOOLS
TOOLS
Sort: Ascending
Show:
Criteria:<25
or:
One mark for each completely correct column (max three)
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.