Computer Science · Oct / Nov 2023 · Paper 23 · Question 9

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

Read automatically from the paper; the printed page above is exact.