Computer Science · May / June 2022 · Paper 21 · Question 6
0478
As printed in the paper
The question as text
A computer game shop records its stock levels in a database table called GAMES. The fields used in the stock table are shown. Name Description GameID primary key GameName the name of each game AgeRestriction the minimum age at which a person is allowed to play each game GamePrice the selling price for each game NumberStock the quantity of each game currently in stock OnOrder whether or not each game is on order from the suppliers DateLastOrdered the date the most recent order for each game was placed GameDescription a summary of the contents and purpose of each game
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
6(a)[1]
8
6(b)[1]
The primary key field must be unique/different for each record in the table
6(c)[3]
One mark per mark point, max three
correct fields and table named correctlycorrect sort and show box rowscorrect search criteriaField: GameID
GameName GamePrice
NumberStock OnOrder
Table: GAMES
GAMES
GAMES
GAMES
GAMES
Sort:
Ascending
Show:
Criteria:=0
="Y"
or:
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.