Computer Science · Oct / Nov 2024 · Paper 22 · Question 11
2210
As printed in the paper
The question as text
A database table called Booking28 stores details of hotel rooms and bookings for the week beginning Monday 7 July 2025. RoomNo Type Guests Rate$ Mon Tue Wed Thu Fri Sat Sun 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]
11(b)[1]
11(c)[2]
11(d)[3]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.