Computer Science (AS & A Level) · May / June 2024 · Paper 13 · Question 4
9618
As printed in the paper
The question as text
A theatre wants to use a database to store data about the shows that are scheduled, their customers and the seats that the customers have booked. In the theatre: • Each show can take place on multiple dates. • Some dates can have more than one performance. • There are multiple rows of seats. • Each seat can be individually booked by its row letter and seat number, for example row E seat 2. Part of the database design includes these tables: SHOW(ShowID, Title, Duration) SEAT(SeatID, RowLetter, SeatNumber) PERFORMANCE(PerformanceID, ShowID, ShowDate, StartTime)
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
4(a)[1]
4(b)[4]
4(c)[4]
4(d)[5]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.