May/June 2026 Paper 23

2026 · 10 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
–/1 mk
Q3
3(a)(i)3(a)(ii)3(b)3(c)
–/11 mks
Q4
4(a)4(b)(i)4(b)(ii)
–/10 mks
Q5
5(a)5(b)
–/7 mks
Q6
6(a)6(b)
–/5 mks
Q7
7(a)7(b)
–/8 mks
Q8
8(a)8(b)8(c)
–/11 mks
Q9
9
–/6 mks
Q10
10
–/15 mks
Context for question 8
A database table OPTION_SUBJECTS stores some data about a number of subjects taken by students in a college.
fielddescription
SubjectCodea code such as CSIG01 to represent the subject and level
SubjectNamethe name of the subject, for example computer science
Levelthe level of the course, for example IGCSE or A Level
CourseWorkwhether or not coursework is included as part of the assessment
PracticalExamsthe number of practical exams taken during the course
TheoryExamsthe number of theory exams taken during the course
CourseLengthlength of the course, for example 1 or 2, representing number of years
MinimumClassSizethe minimum number of students required for the course to run, for example 10
MaximumClassSizethe maximum number of students admitted to each class, for example 30
8(a)Relational Databases Data ModellingEasy2 marks
Identify the most appropriate field in OPTION_SUBJECTS for a primary key. Give one reason for your choice.
Field
Reason
0 words
8(b)Relational Databases Data ModellingMedium4 marks
Identify one appropriate field from OPTION_SUBJECTS for each of the given data types. State one reason for your choice in each case.
Integer data type: field and reason
0 words
Boolean data type: field and reason
0 words
8(c)Sql QueriesHard5 marks
Complete the structured query language (SQL) statement to list only the subject code, subject name and level for the minimum class size of less than 10. The results should be listed in order of subject code, from the lowest to the highest.
0 words