Computer Science · Oct / Nov 2023 · Paper 21 · Question 9
0478
As printed in the paper
The question as text
A model shop wants to set up a database to help with stock control of the model figures available for sale. The shop wants to store this information about the model figures: Field 1 – catalogue number, for example MD1234 Field 2 – description, for example ‘small white dog’ Field 3 – number in stock, for example 5 Field 4 – the price of each model, for example 7.40 Field 5 – if the model has already been painted, yes or no.
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
9(a)[5]
One mark for each appropriate field name and correct data type
CatNo
text/alphanumeric
Description text/alphanumeric
StockLevel integer
Price
real
Painted
Boolean
9(b)(i)[1]
CatNo
9(b)(ii)[1]
Unique identifier
9(c)[3]
SELECT lists the fields to be displayed
FROM identifies the table
WHERE identifies the search criteria
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.