Computer Science · Oct / Nov 2025 · Paper 22 · Question 7
0478
As printed in the paper
The question as text
A database table ¢|y}¢{ stores some details of a range of birds found in the UK that live on or near water. The length and wingspan dimensions are in centimetres and the typical lifespan is in years. ÆpÅâãÅä åæçãèé êÅnëÇb íãnëäpæn ÂÃæäÇæèîæïãÇæÇ êãðÅäpæn Barnacle goose Goose 63.5 130.0 FALSE 14 Bewick’s swan Swan 120.2 190.5 TRUE 8 Brent goose Goose 58.0 94.3 TRUE 11 Canada goose Goose 78.5 160.0 FALSE 6 Eider Duck 58.0 94.5 TRUE 8 Goldeneye Duck 44.5 72.1 TRUE 6 Goosander Duck 63.3 90.0 TRUE 7 Long-tailed duck Duck 44.0 76.6 TRUE 5 Mallard Duck 59.7 90.8 FALSE 3 Mute swan Swan 150.0 220.2 FALSE 10 Pink-footed goose Goose 69.6 150.0 TRUE 8 Pintail Duck 60.0 88.6 TRUE 3 Smew Duck 41.5 62.1 FALSE 7 White-fronted goose Goose 71.5 140.0 FALSE 6 Whooper swan Swan 150.0 230.0 TRUE 9
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
7(a)[1]
It is used to uniquely identify records
7(b)[2]
Two marks for all four fields correctly identified
One mark for two or three fields correctly identified
Data type
Field
Boolean
CoastalHabitat
Integer
Lifespan
Real
Length // Wingspan
Text
Species // Family
7(c)[3]
One mark per mark point, max three
MP1
Correct data – spelt correctly
MP2
Correct layout – three columns, with no additional punctuation
MP3
Correct order (vertical and horizontal)
Correct output:
Bewick’s swan
120.2
190.5
Whooper swan
150.0
230.0
Mute swan
150.0
220.2
7(d)[4]
One mark per correct line, max four
SELECT Species, Family, Lifespan
FROM WATERFOWL
WHERE Lifespan >= 10 ORDER BY Species;
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.