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 | (a) State how many fields and how many records are shown in the AIRLINE table. Number of Fields \_\_\_\_ Number of Records \_\_\_\_ [2] (b)Show the output that would be given by this query-by-example. | Field: | Airline name | Number of employees | Head office | Share price | | :--- | :--- | :--- | :--- | :--- | | Table: | AIRLINE | AIRLINE | AIRLINE | AIRLINE | | Sort: | | | | | | Show: | ✓ | □ | ✓ | □ | | Criteria: | | 500.00 | | or: | | | | | \_\_\_\_ \_\_\_\_ \_\_\_\_ [2] (c) Complete the query-by-example grid to find every airline with a head office in Asia or Africa, and number of countries greater than 4. Only show the airline name and number of countries. Field: ![](https://files.sudostudy.com/97612aeadd753898fb287d73bf5b87b3e853137d3954e4c33a65afc402edf48c.jpg?height=305&width=1581&top_left_y=353&top_left_x=316) Sort: □ Show: □ Criteria: □ or: □

2020 - O/N - 0478/21 | Q5

0/5

0 correct · 0 wrong

A database table, AIRLINE, stores data used to compare ai...