Computer Science · Oct / Nov 2016 · Paper 23 · Question 6
2210
As printed in the paper
The question as text
A database, THEATRETOURS, was set up to show the tour dates, towns, number of seats and prices in local currency for a Shakespeare play. Town Tour Date Number of Seats Price Local Currency Wigan 18/08/2016 120 15.00 Dumfries 20/08/2016 160 12.50 Turin 25/08/2016 200 17.00 Macon 27/08/2016 75 18.00 Bordeaux 29/08/2016 170 20.00 Algiers 01/09/2016 125 1350.00 Windhoek 05/09/2016 65 90.00 Windhoek 06/09/2016 65 90.00 Port Elizabeth 10/09/2016 200 110.00
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
6(a)[2]
– Town has duplicate entries/all fields can have duplicate entries – fields other than Town not suitable identifiers [2]
6(b)[2]
– Performance number … – … uniquely identifies each performance [2]
6(c)[4]
Field: Town Tour Date Price Local Currency Table: THEATRETOURS THEATRETOURS THEATRETOURS Sort: Ascending Show: ;
;
;
Criteria: or: 1 mark for each column + 1 mark for correct fields only [4]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.