1c 1 mark each for: Fields required: all fields created with correct serialNumber text — data dateBuilt date — primary key (serialNumber) timeCompleted time — presence check on every field text — 6 restricted choice on with testPassed Boolean — (8) correct three options employeeNumber FK — length = 10 characters on serialNumber linked table enforcing referential integrity Implementation 1d 1 mark each for: Sample answer: INSERT INTO Employee INSERT INTO Employee 2 VALUES (1599, ‘Jeremy’, correct data, in correct Red Lane’, ‘May’, ‘67 ‘07923782534’,true); Expected response Additional guidance Task Marks available 2 Software design and development 2a Array used in program 1 Use of the following variables: Variable names may differ in code total hits 1 All three variables are required average (15) for 1 mark points Fixed loop repeating six times (to 1 enter player hits) Input validation conditional — 1 loop used Input validation correct loop hits >= 0 and hits <= 30 — Implementation 1 condition Input validation input of player 1 mark if not implemented — 1 hits within input validation loop
1c 1 mark each for: all fields created with correct data primary key (serialNumber) presence check on every field restricted choice on with correct three options length = 10 characters on serialNumber linked table enforcing referential integrity Fields required: serialNumber — text dateBuilt — date timeCompleted — time — text testPassed — Boolean employeeNumber — FK 6 Implementation (8) 1d 1 mark each for: INSERT INTO Employee correct data, in correct Sample answer: INSERT INTO Employee VALUES (1599, ‘Jeremy’, ‘May’, ‘67 Red Lane’, ‘07923782534’,true); 2 Task Expected response Additional guidance Marks available 2 Software design and development 2a Array used in program 1 Implementation (15) Use of the following variables: total hits average points Variable names may differ in code All three variables are required for 1 mark 1 Fixed loop repeating six times (to enter player hits) 1 Input validation — conditional loop used 1 Input validation — correct loop condition hits >= 0 and hits <= 30 1 Input validation — input of player hits 1 mark if not implemented within input validation loop 1
ComputingScienceCATN5.docx