Document page
Computer Science IGCSEPDF 130
142 pagesrevision 46930
PDF 130
Page image rendered from the stored file at 110 dpi; it sharpens as you zoom. Outlines are placed from each region’s stored position on the page (612 × 792 pt).
no text layerread by OCR (tesseract5-eng@250dpi)The text layer was unusable, so the page image was read by OCR. OCR text can contain misread characters.
Source of this text: read by OCR. The better of the embedded text and OCR is kept.
Species Description NumberBirds | Breeding | Young
Edwards blue-black with white tail § 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 t 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 M4 Yes 0
Himalayan monal | many colours with metallic green crest a 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
(a) State the number of records and fields in this part of the database table.
ore): ROB RS EO BEES Opn EC ene RESP SER” SeEOEPE aT DESDE PREP PEE PTT OCI SORE ETEOT CSET ONCODES REO G OSD At Eon Se EY
FDIC sce res Sater cose eee eR
(2)
(b) (i) Give the name of a field that could be used for the primary key.
SE a a aS ere [1]
(ii)
(iii)
Anew 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.