O-LevelComputer ScienceDatabases2210/21 · May/June 2022 · Q65 Marks
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
- (a)State the number of fields that are in the table GAMES.[1]
- (b)State one important fact that must be true for a field to be a primary key.[1]
- (c)Complete the query-by-example grid to output all the games that have no stock and that are on order with the supplier. Display only the GameID, GameName and GamePrice fields in alphabetical order of the name of the game.[3]
Mark scheme
Marking points from the official mark scheme (May/June 2022). The mark or mark type is shown in brackets.
- [1] 8
- [1] The primary key field must be unique/different for each record in the table
- [3] One mark per mark point, max three
- • correct fields and table named correctly
- • correct sort and show box rows
- • correct search criteria
- Field: GamelD GameName GamePrice NumberStock OnOrder
- Table: GAMES GAMES GAMES GAMES GAMES
- Sort: Ascending
- Show: ✔ ✔ ✔
- Criteria: =0 ="Y"
Write your answer and get it marked
On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.
Sign up free →