Computer Science · May / June 2022 · Paper 22 · Question 5
0478
As printed in the paper
The question as text
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
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
5(a)[4]
One mark per mark point, max four
correct rows Field and Tablecorrect row Showcorrect Criteria for SingleUse or/and Usescorrect Criteria for StockLevel less than ReorderLevelField: ItemNumber
Description
SingleUse
StockLevel
Table: NURSE
NURSE
NURSE
NURSE
Sort:
Show:
Criteria:True
<[ReorderLevel]
or:
Or
Field: ItemNumber
Description
Uses
StockLevel
Table: NURSE
NURSE
NURSE
NURSE
Sort:
Show:
Criteria:= 1
<[ReorderLevel]
or:
5(b)[1]
the field Uses already shows this information // duplication of data // redundant data
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.