Computer Science · Oct / Nov 2020 · Paper 21 · Question 5
0478
As printed in the paper
The question as text
A database table, AIRLINE, stores data used to compare airlines. Code Airline name Number of employees Number of countries Head office Share price FJ FastJet 60000 30 Europe 514.50 MA MurphyAir 35000 8 Europe 152.67 JS JetSeven 45000 22 Asia 257.44 K3 Koala3 22000 11 Australia 501.21 NS NorthState 30000 4 America 108.22 SS SouthState 30000 4 America 126.35 BJ BlueJet 15000 7 Africa 215.45 SK SkyKing 32000 27 Europe 506.12 PF PandaFly 50000 35 Asia 317.88
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
5(a)[2]
6 fields
9 records
5(b)[2]
Either mark by row or by column but not both
One each correct row or one mark for each correct column max two Koala3
Australia
SkyKing
Europe
5(c)[4]
Field:
Airline name
Number of
Head office countries
Table:
AIRLINE
AIRLINE
AIRLINE Sort:
Show:
Criteria:> 4
="Asia"
or:
> 4
="Africa" one mark for correct fields and correct table names, must have the three columns required, ignore another column provided the show row is not ticked and there are no criteria set for that column
one mark for correct show row
one mark for correct number of countries criteria
one mark for correct head office criteria
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.