Computer Science · Oct / Nov 2024 · Paper 21 · Question 10
0478
As printed in the paper
The question as text
A shop that sells cheese has set up a new database table called ž¾¾¹¯ÔÕ to store details of the cheeses available for sale. Part of this table is given. ÖbØÙ ØÑÎÍ ÚnÜÒÙÝk ÜuppßàÍÐÖÙáÍ âÐàÝÍâÍÐãä åÍàäbÒãä CH01 American Yes XYZ 4.50 20.0 CH02 Brie Yes XYZ 7.50 21.0 CH03 Burrata No IMP 13.75 0.0 CH04 Camembert No ABC 16.85 0.0 CH05 Cheddar Yes ABC 5.00 50.0 CH06 Comte No SPC 7.35 0.0 CH07 Cottage Yes XYZ 4.50 3.0 CH08 Cream Yes XYZ 5.50 6.5 CH12 Emmental Yes IMP 2.75 1.5 CH15 Feta Yes IMP 12.75 12.0 CH16 Fontina Yes SPC 15.99 1.2 CH17 Gorgonzola Yes SPC 15.25 0.3 CH19 Gouda Yes SPC 7.99 2.5 CH21 Gruyere No SPC 16.75 0.0 CH22 Halloumi Yes IMP 4.75 15.0 CH23 Havarti No SPC 6.75 0.0 CH27 Manchego No IMP 13.99 0.0 CH30 Manouri No IMP 18.50 0.0 CH31 Mascarpone No SPC 12.99 0.0
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
10(a)[1]
19
10(b)(i)[1]
ChNo
10(b)(ii)[1]
Unique identifier
10(c)[2]
One mark for each
CH04 0.0CH05 50.010(d)(i)[3]
One mark each correct line
SELECT Name
FROM CheeseStock
WHERE NOT InStock // InStock = No / "No" / False // WHERE WeightKg = 0.0;
10(d)(ii)[2]
One mark for each point
WHERE clause can check either the InStock field for FALSE / No / "No" orthe WeightKg field for 0.0
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.