May/June 2026 Paper 21

2026 · 12 questions · 20 parts · 75 marks

0/75 marks
0Correct0Partial0Wrong20Unattempted
Filters0 active

Questions

Select a part to jump to its question

Finish set
Q1
1
–/1 mk
Q2
2
–/4 mks
Q3
3
–/3 mks
Q4
4
–/4 mks
Q5
5(a)5(b)5(c)5(d)
–/12 mks
Q6
6
–/4 mks
Q7
7
–/4 mks
Q8
8(a)8(b)
–/7 mks
Q9
9(a)(i)9(a)(ii)9(b)9(c)
–/7 mks
Q10
10(a)10(b)
–/9 mks
Q11
11
–/5 mks
Q12
12
–/15 mks
Context for question 9
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 SWIMMERS and will contain these fields: • Distance – distance the member swam, for example 1500 • Date – date the member swam the distance • Time – time taken to swim the distance • MemberID – the code to identify a member, for example TH749 • MemberName – name of the member.
9(a)(i)Relational Databases Data ModellingEasy1 mark
State why MemberName would not be appropriate for a primary key.
9(a)(ii)Relational Databases Data ModellingEasy1 mark
Give the name of the most appropriate field for the primary key.

Answer

9(b)Relational Databases Data ModellingEasy2 marks
Complete the table to identify the most appropriate data type for these fields in the table SWIMMERS. Each data type must be different.
fielddata type
Distance
Date
MemberID
9(c)Sql QueriesMedium3 marks
Complete the structured query language (SQL) statement to display only the names of the members who swam a distance of 1500 metres or more.