Computer Science · Oct / Nov 2016 · Paper 22 · Question 5
2210
As printed in the paper
The question as text
A database, PLAYPRODUCTION, was set up to show the performance dates, prices and number of seats available at a theatre specialising in Shakespeare productions. Play Performance Date Number Seats Stalls Number Seats Circle Price Stalls Seats $ Price Circle Seats $ As You Like It 01/07/2016 120 90 20.00 30.00 As You Like It 02/07/2016 85 45 30.00 40.00 As You Like It 09/07/2016 31 4 30.00 40.00 Macbeth 14/07/2016 101 56 25.00 35.00 Macbeth 15/07/2016 50 34 25.00 35.00 Macbeth 16/07/2016 12 5 35.00 50.00 Julius Caesar 22/07/2016 67 111 20.00 20.00 Julius Caesar 23/07/2016 21 24 15.00 15.00 A Comedy of Errors 30/07/2016 45 36 35.00 45.00
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
5(a)[1]
– 6 [1]
5(b)[3]
– Play text – No Seats Stalls number – Price Stalls Seats $ currency [3]
5(c)[3]
1 mark for correct plays, 1 mark for correct dates with each play and no extra fields or text, 1 mark for the order As You Like It 01/07/2016 Julius Caesar 22/07/2016 Macbeth 14/07/2016 [3]
5(d)[5]
Field: Play Performance Date Number Seats Circle Price Circle Seats $ Table: PLAYPRODUCTION PLAYPRODUCTION PLAYPRODUCTION PLAYPRODUCTION Sort: Ascending/ Descending Show: ;
;
;
Criteria: >=6 or: (1 mark) (1 mark) (2 marks) 1 for Criteria 1 for correct Field & Table & Sort & Show & or (1 mark) [5]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.