Computer Science · May / June 2026 · Paper 21 · Question 9
0478
As printed in the paper
The question as text
A swimming club wants to set up a new database table to store details of the members of the club and the maximum distance each member swam in metres. The table is called ªÁ~ª and will contain these fields: • }À£¨É – distance the member swam, for example 1500 • }¨ – date the member swam the distance • À – time taken to swim the distance • ~} – the code to identify a member, for example TH749 • | – name of the member.
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
9(a)(i)[1]
As MemberName may be repeated/not unique
9(a)(ii)[1]
MemberID
9(b)[2]
One mark for two correct data types, two marks for three correct data types
field
data type
Distance
Integer //Real//text//alphanumeric
Date
Date/Time //text//alphanumeric
MemberID
Text //alphanumeric
9(c)[3]
One mark for each correct line
SELECT MemberName
FROM SWIMMERS
WHERE Distance >= 1 500;
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.