O-LevelComputer ScienceDatabases2210/22 · Oct/Nov 2024 · Q108 Marks

A database table called Booking28 stores details of hotel rooms and bookings for the week beginning Monday 7 July 2025. [Table 10.1 (Booking28 data)]

(a)State the number of fields and records in this database table. Fields Records[2]
(b)State the reason why the Type field would not be suitable as a primary key.[1]
(c)The database uses only the data types: • alphanumeric • character • Boolean • integer • real • date/time. Complete the table to show the fields that could have the given data types. Only one field name is required in each box and each field name must be different. Field | Data type --|--- alphanumeric Boolean real integer[2]
(d)Give the output that would be produced by the structured query language (SQL) statement: SELECT RoomNo, Type, Guests, Rate$ FROM Booking28 WHERE Mon <> T;[3]

Mark scheme

Marking points from the official mark scheme (Oct/Nov 2024). The mark or mark type is shown in brackets.

[1] Fields - 11
[1] Records - 15
[1] The Type field contains data that repeats / Data is not unique
[2] Two marks for four correct fields
[1] One mark for two or three correct fields
[1] Data from 4 correct columns printed – any number of rows, any order
[1] Data in rows ordered as shown (row and column) at least two rows and two columns required
[1] All data correct with no extra content

On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.