6 A database table, TREES, is used to keep a record of the trees in a park. Each tree is given a unique number and is examined to see if it is at risk of dying. There are over 900 trees; part of the database table is shown. [Table provided] Tree Number | Type | Map Position | Age in Years | At Risk TN091 | Acacia | A7 | 250 | Y TN172 | Olive | C5 | 110 | N TN913 | Cedar | B9 | 8 | N TN824 | Banyan | A3 | 50 | Y TN021 | Pine | D5 | 560 | Y TN532 | Teak | C8 | 76 | Y TN043 | Yew | B1 | 340 | N TN354 | Spruce | D4 | 65 | N TN731 | Elm | B10 | 22 | Y TN869 | Oak | C9 | 13 | N TN954 | Pine | E11 | 3 | N

1. (a)State the number of fields in the table.[1]
2. (b)The tree numbering system uses TN followed by three digits. The numbering system will not work if there are over 1000 trees. Describe, with the aid of an example, how you could change the tree numbering system to allow for over 1000 trees. Existing tree numbers must not be changed.[2]
3. (c)Using the query-by-example grid, write a query to identify at risk trees over 100 years old. Display only the type and the position on the map. Field: Table: Sort: Show: [checkboxes] Criteria: 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.