Computer Science · May / June 2021 · Paper 21 · Question 6
0478
As printed in the paper
The question as text
A library uses a database table, GENRE, to keep a record of the number of books it has in each genre. ID GenreName Total Available Loaned Overdue ABI Autobiography 500 250 250 20 BIO Biography 650 400 250 0 EDU Education 20200 10000 10200 1250 FAN Fantasy 1575 500 1075 13 GFI General Fiction 35253 23520 11733 0 GNF General Non-Fiction 25200 12020 13180 0 HFI Historical Fiction 6300 3500 2800 0 HNF Historical Non-Fiction 8000 1523 6477 0 HUM Humour 13500 9580 3920 46 MYS Mystery 26000 13269 12731 0 PFI Political Fiction 23561 10523 13038 500 PNF Political Non-Fiction 1823 750 1073 23 REF Reference 374 374 0 0 ROM Romance 18269 16800 1469 0 SAT Satirical 23567 12500 11067 0 SCF Science Fiction 36025 25000 11025 0 SPO Sport 45720 32687 13033 3256 THR Thriller 86000 46859 39141 0
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
6(a)[1]
The data in the ID column/field is unique/not repeated in each row/record
6(b)[1]
18
6(c)[4]
Field: ID
GenreName
Overdue
Table: GENRE
GENRE
GENRE
Sort:
Descending
Show:
Criteria:>0
or:
One mark for the correct fields present and correctly named
One mark for correct table name and show box in all columns
One mark for correct sorting
One mark for correct search criterion
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.