A database table, PERFORMANCE, is used to keep a record of the performances at a local theatre. | Show Number | Type | Title | Date | Sold Out | |-------------|-----------|---------------------------|----------|----------| | SN091 | Comedy | An Evening at Home | 01 Sept | Yes | | SN102 | Drama | Old Places | 02 Oct | No | | SN113 | Jazz | Acoustic Evening | 03 Nov | No | | SN124 | Classical | Mozart Evening | 04 Dec | Yes | | SN021 | Classical | Bach Favourites | 01 Feb | Yes | | SN032 | Jazz | 30 Years of Jazz | 02 Mar | Yes | | SN043 | Comedy | Street Night | 03 Apr | No | | SN054 | Comedy | Hoot | 04 May | No |

1. (a)State the number of fields and records in the table.[2]
2. (b)Give two validation checks that could be performed on the Show Number field.[2]
3. (c)Using the query-by-example grid, write a query to identify jazz performances that are not sold out. Only display the date and the title. Field: Show Number Type Title Date Sold Out Table: Performance Performance Performance Performance Performance Sort: Show: Criteria: Jazz = No or:[4]

This question uses a diagram from the original paper, which isn't shown here. Open the full paper from the past papers archive to see it.