Computer Science · May / June 2016 · Paper 21 · Question 6
2210
As printed in the paper
The question as text
A database, STAFFPHONE, was set up to show the telephone extension numbers for members of staff working in a department store. Name Department Extension number Jane Smith Toys 129 Sue Wong Books 124 David Chow Toys 129 Amy Tang Household 123 Joe Higgs Books 124 Jane Smith Shoes 125 Adel Abur Shoes 125 Peter Patel Toys 129
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
6(a)[2]
– all (fields) have (1 mark) duplicate entries (1 mark) – none (of the fields) (1 mark) have unique entries(1 mark) [2]
6(b)[2]
– e.g. StaffNumber …. – ….. Uniquely identifies each member of staff//no duplicates//different for each member of staff [2]
6(c)[5]
Field: Department Name Table: STAFFPHONE STAFFPHONE Sort: Ascending Ascending Show: ✓ ✓ Criteri a: or: (2 marks) (2 marks) (1 mark for correct order and number of fields shown) [5]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.