O-LevelComputer ScienceDatabases2210/21 · May/June 2016 · Q69 Marks
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
- (a)Explain why none of the fields in the database can be used as a primary key.[2]
- (b)State a field that could be added as a primary key. Give a reason for choosing this field.[2]
- (c)Use the query-by-example grid below to provide a list of all members of staff, in alphabetical order, grouped by department. Field: Table: Sort: Show: Criteria: or:[5]
Mark scheme
Marking points from the official mark scheme (May/June 2016). The mark or mark type is shown in brackets.
- [2] 6 (a) – all (fields) have (1 mark) duplicate entries (1 mark) – none (of the fields) (1 mark) have unique entries(1 mark)
- [2] (b) - e.g. StaffNumber .... – Uniquely identifies each member of staff//no duplicates//different for each member of staff
- [5] (c) 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)
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 →