Note AcademyNote Academy
Start

Computer Science · Oct / Nov 2025 · Paper 21 · Question 8

0478

As printed in the paper

The question as text

A school has set up a database table {µ³œœŸx¾°Ø to record details of students that will go on a school trip. ÙÏuÚÓnÏÛÜ ÙÏuÚÓnÏÐÖÑÓ ÝÖÔÓnÏÐÖÑÓ ÝÓÔÑÞßßÞÌn ÜÖÏÓàÓáÓÞâÓÚ STU147 Amir Mr Akar True 03/03/2025 STU348 Filip Mrs Johnson True 04/03/2025 STU274 Matthew Mr Smith False STU873 Jafar Mr Al-Saigh True 21/03/2025 STU221 Hussein Mr Alkasab True 28/02/2025 STU553 Julie Mrs Jones True 25/02/2025 STU213 Julie Mr Smith False

Read automatically from the paper; the printed page above is exact.

Show the answer and mark scheme

  • 8(a)[1]

    One mark from:

    parent name can be repeated
    not unique

  • 8(b)[1]

    StudentID

  • 8(c)[2]

    Two marks for 3 correct data types or one mark for 1 or 2 correct data types

    Field

    Data type

    ParentName

    Text

    Permission

    Boolean/text

    DateReceived Date/time/text

  • 8(d)[2]

    One mark if two correct, Two marks if all three correct

    SELECT StudentName

    FROM SchoolTrip

    WHERE Permission = False;

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.