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 |

1. (a)Give the number of fields that are in each record.[1]
2. (b)State the data type you would choose for each of the following fields. Play Number Seats Stalls Price Stalls Seats $[3]
3. (c)The query-by-example grid below selects all the productions with more than 100 seats left in either the stalls or the circle. Field: Play Performance Date Number Seats Stalls Number Seats Circle Table: PLAYPRODUCTION PLAYPRODUCTION PLAYPRODUCTION PLAYPRODUCTION Sort: Ascending Show: [checkbox checked] [checkbox checked] [checkbox unchecked] [checkbox unchecked] Criteria: > 100 or: > 100 Show what would be output from the query-by-example.[3]
4. (d)Complete the query-by-example grid below to select all the productions with at least six seats left in the circle and show the Play, Performance Date and Price Circle Seats $ in Performance Date order. Field: Table: Sort: Show: Criteria: or:[5]