Computer Science · Oct / Nov 2021 · Paper 22 · Question 6
0478
As printed in the paper
The question as text
A pet supplier uses the database table, STOCK, to keep records of its products for pets. The fields are: Field name Description ProductID code to identify the product ProductName name of product ProductDescription information about the product Animal type of animal the product is for, e.g. cat, bird, horse ProductType type of product, e.g. food, toy, medicine InStock whether the product is in stock or not
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
6(a)(i)[1]
InStock
6(a)(ii)[1]
ProductID
6(b)[4]
One mark for correct fieldnames
One mark for correct table names and show fields
One mark for correct sort
One mark for correct search criteria in all columns
Field: ProductID
ProductName
Animal
InStock
Table: STOCK
STOCK
STOCK
STOCK
Sort: Ascending
Show:
Criteria:=“cat”
=Yes
or:
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.