O-LevelComputer ScienceDatabases2210/22 · May/June 2022 · Q55 Marks
A database table, NURSE, is used to keep a record of disposable items worn by veterinary nurses. This is part of the table: ItemNumber | Description | SingleUse | Uses | StockLevel | ReorderLevel --- | --- | --- | --- | --- | --- DIG1 | Glove (pair) | Y | 1 | 500 | 800 DIA1 | Apron | Y | 1 | 700 | 800 DIM5 | Hair net | Y | 1 | 650 | 500 DIA2 | Apron | N | 5 | 25 | 100 DIS4 | Suit | N | 3 | 70 | 50 DIV9 | Shoe cover (pair) | Y | 1 | 400 | 250
- (a)Complete this query-by-example grid to display only the item number and the description of single use items, where the stock level is below the reorder level. Field: Table: Sort: Show: Criteria: or:[4]
- (b)Give a reason why the field SingleUse is not required in the table NURSE.[1]
This question uses a diagram from the original paper, which isn't shown here. Open the full paper from the past papers archive to see it.
Mark scheme
Marking points from the official mark scheme (May/June 2022). The mark or mark type is shown in brackets.
- [1] correct rows Field and Table
- [1] correct row Show
- [1] correct Criteria for SingleUse or/and Uses
- [1] correct Criteria for StockLevel less than ReorderLevel
- [1] the field Uses already shows this information // duplication of data // redundant data
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 →