Note AcademyNote Academy
Start

Computer Science · May / June 2026 · Paper 22 · Question 9

0478

As printed in the paper

Show the answer and mark scheme

  • 9(a)[4]

    One mark for every two correct data types

    field

    data type

    description

    uniquely identifies the car part PartID

    text

    with letters and numbers name of the car part, for example PartName

    text

    windscreen wiper

    four-digit number code to CarType

    integer/text

    represent the car type

    Price

    real

    selling price to 2 decimal places specifies the size if relevant, Size

    text

    otherwise would say ‘one size’ single letter code for the colour Colour

    character

    of the item

    NumberInStock

    Integer

    the number of car parts in stock Boolean/text/character/

    whether or not the part is in InStock

    integer

    stock

  • 9(b)[4]

    One mark each

    At least two correct fields in SELECT row
    Remaining correct field in SELECT row
    Correct FROM CAR_PARTS
    Correct WHERE PartName = "brake pads";

    Correct code:

    SELECT PartID, CarType, NumberInStock

    FROM CAR_PARTS

    WHERE PartName = "brake pads"; // PartName = 'brake pads';

  • 9(c)[2]

    One mark each

    There is an alternative field NumberInStock
    … a value of 0 in this field indicates the item is out of stock // … a positive value in this field indicates the item is in stock // … this field indicates the quantity in stock
Practise this paper →

Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.