Specific marking instructions Task Expected response Additional guidance Marks available 1 Database design and development part A — 1a 1 mark for identifying: employee number 1 mark for identifying: (2) 2 first name Must identify all five surname Analysis attributes address (or street, town) telephone number driving licence 1b 1 mark for completion of each row: No marks awarded for application specific field serialNumber PK types in column — “Type” (for example date/time, timeCompleted time — (5) yes/no) 5 model restricted choice: Jazz8, — Rock100 and Blues55 Design Restricted choice must testPassed Boolean — list all three choices employeeNumber FK — Task Expected response Additional guidance Marks available 1 Database design and development part B —
Specific marking instructions Task Expected response Additional guidance Marks available 1 Database design and development — part A 1a 1 mark for identifying: employee number 1 mark for identifying: first name surname address (or street, town) telephone number driving licence Must identify all five attributes 2 Analysis (2) 1b 1 mark for completion of each row: serialNumber — PK timeCompleted — time model — restricted choice: Jazz8, Rock100 and Blues55 testPassed — Boolean employeeNumber — FK No marks awarded for application specific field types in “Type” column (for example date/time, yes/no) Restricted choice must list all three choices 5 Design (5) Task Expected response Additional guidance Marks available 1 Database design and development — part B
ComputingScienceCATN5.docx