A sanctuary for pheasants has set up a new database table called PheasantList to store details of the different species of bird at the sanctuary. Part of this table is given, showing: species, description, number of birds at the sanctuary, if the birds are breeding or not, and number of young born this year. Species | Description | NumberBirds | Breeding | Young Edwards | blue-black with white tail | 5 | Yes | 0 Japanese green | dark green with pale grey tail | 2 | Yes | 2 Reeves | golden, white and red scaled plumage | 4 | Yes | 1 Crawfords Kalij | glossy blue-black plumage | 4 | No | 0 Crested fireback | blue-black with black tail | 3 | No | 0 True silver | white laced top half and black lower half | 7 | Yes | 1 Siamese fireback | grey plumage with crimson legs and feet | 5 | No | 0 Mikado | iridescent plumage with white striped wings | 3 | Yes | 4 Red junglefowl | many colours | 2 | Yes | 0 Himalayan monal | many colours with metallic green crest | 3 | Yes | 2 White eared | white with ear tufts | 5 | Yes | 3 Brown eared | brown with ear tufts | 9 | Yes | 1 Ring necked | long tail with white ring neck | 2 | Yes | 2 Golden | rainbow coloured | 3 | Yes | 4

1. (a)State the number of records and fields in this part of the database table. Records Fields[2]
2. (b)(i)Give the name of a field that could be used for the primary key.[1]
3. (b)(ii)Explain why the sanctuary might decide not to use the field in (b)(i) as the primary key.[1]
4. (b)(iii)A new field SpeciesID is added to the database table. This field contains a six-character code, for example Ph0001. Give a reason why this field would be a better primary key.[1]
5. (c)Write the output that would be given by this structured query language (SQL) statement: SELECT Species, Description FROM PheasantList WHERE NumberBirds > 6;[2]
6. (d)Complete this SQL statement to display all the species of pheasant where the birds are breeding and there were no young born this year: SELECT FROM WHERE ;[4]