May/June 2026 Paper 22

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
–/6 mks
Q5
5(a)5(b)5(c)
–/10 mks
Q6
6(a)6(b)
–/7 mks
Q7
7(a)7(b)
–/5 mks
Q8
8(a)8(b)
–/9 mks
Q9
9(a)9(b)9(c)
–/10 mks
Q10
10
–/15 mks
9(a)Relational Databases Data ModellingMedium4 marks
A database table CAR_PARTS stores details of car parts that a business has in stock.
Complete the table by giving the most appropriate data types for each field.
Only the data types: text, character, Boolean, integer, real and date/time are available in this database.
fielddata typedescription
PartID
unique code to identify the car part with letters and numbers
PartName
name of the car part, for example windscreen wiper
CarType
four-digit number code to represent the type of car
Price
selling price to 2 decimal places
Size
specifies the size if relevant, otherwise stores ‘one size’
Colour
single letter code for the colour of the car part
NumberInStock
the quantity of car parts in stock
InStock
whether or not the car part is in stock
9(b)Sql QueriesMedium4 marks
Complete the structured query language (SQL) statement to list only the part ID, type of car and the quantity in stock of all the car parts that are brake pads.
0 words
0 words
9(c)Relational Databases Data ModellingMedium2 marks
Describe one reason why the InStock field is not needed in the table.

Answer

0 words