Note AcademyNote Academy
Start

Computer Science · Oct / Nov 2024 · Paper 22 · Question 11

0478

As printed in the paper

The question as text

A database table called ²vvØyz{„´ stores details of hotel rooms and bookings for the week beginning Monday 7 July 2025. ÚÂÂÛÜ ÝÞpÀ àuÀÆÄÆ Ú½ÄÀá âÂn ÝuÀ ãÀä Ýbu æÈç è½Ä èun 101D Double 2 99.99 T T T T F T T 102D Double 2 99.99 T T T F T T T 103F Family 4 150.00 T T T T T T T 104S Single 1 72.50 F T T F T T T 105S Single 1 72.50 F T T F T T T 106T Twin 2 120.00 T T T T F T T 201F Family 4 160.00 F F T T T T T 202D Double 2 120.00 T F T T T T T 203T Twin 2 120.00 T F T T T T T 204T Twin 2 125.00 T F T F T T T 205S Single 1 79.99 T F T T F T T 301D Double 2 200.00 F T T F F T T 302T Twin 2 200.00 T T T T F T T 303P Suite 4 500.00 T T T T F T T 304P Suite 6 700.00 F F F F T T T

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

Show the answer and mark scheme

  • 11(a)[2]

    One mark per mark point

    Fields – 11
    Records – 15

  • 11(b)[1]

    The Type field contains data that repeats / Data is not unique

  • 11(c)[2]

    Two marks for four correct fields

    One mark for two or three correct fields

    Field

    Data type

    RoomNo // Type

    alphanumeric

    Mon // Tue // Wed // Thu // Fri // Sat // Sun Boolean

    Rate$

    real

    Guests

    integer

  • 11(d)[3]

    One mark per mark point

    Data from 4 correct columns printed – any number of rows, any order
    Data in rows ordered as shown (row and column) at least two rows and two columns required
    All data correct with no extra content

    Correct output

    104S Single 1 72.50

    105S Single 1 72.50

    201F Family 4 160.00

    301D Double 2 200.00

    304P Suite 6 700.00

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.