Question 10
Question
In the question paper above.
Mark scheme
10(b)(i) TWO marks available: 2 First mark for identifying a suitable validation rule/test (1st) Second mark for a description of that test (1) • Range (1st) – to check value is BETWEEN two figures (1) • Type – to check data is in numeric/currency • Format check – to check entered as (e.g.) $3.14//description of • Lookup check – to check against a list of values • Limit check – to check that is not below//above a certain figure • Character check – to check that is a decimal/real Trace ID: PC-619A44DAC1 Re-uploading, mirroring or re-hosting this file on any other website or domain is unauthorised and traceable. Licensed for hosting on papacambridge.com only. PapaCambridge Downloaded from PapaCambridge - https://papacambridge.com/ 10(b)(ii) TWO marks available: 2 First mark for identifying a suitable validation test (1st) Second mark for a description of that test (1) • Range – to check value is BETWEEN two figures • Type – to check data is in numeric/date • Format check – to check entered as (e.g.) dd/mm/yyyy • Limit check – to check that is not below/above a certain figure • Character check – to check that is an integer 10(c) THREE marks available: 3 • Age is based on the calculation between date of birth and today (1) • Age constantly increases with time//age changes every year (1) • A calculated field allows for a changing/dynamic figure (1) • The result shown//age is constantly accurate (1st) Reduced chance of human error resulting in the wrong number being stored (1) Trace ID: PC-619A44DAC1 Re-uploading, mirroring or re-hosting this file on any other website or domain is unauthorised and traceable. Licensed for hosting on papacambridge.com only. PapaCambridge Downloaded from PapaCambridge - https://papacambridge.com/