Database Evaluation
Evaluate database solutions using evidence about fitness for purpose and accuracy of output.
How to study Higher Computing Science
Move from requirements to structured designs, trace code and data precisely, and support every test or evaluation judgement with observable evidence.
Core concepts
Concept 1
Fitness for purpose is judged by whether the implemented database meets the analysed end-user and functional requirements.
Exam cue: Quote the requirement and the observed database behaviour.
Concept 2
Accuracy of output depends on correct source data, relationships, criteria, calculations, grouping and sorting.
Exam cue: Trace an inaccurate output back to data, relationship or query logic.
Concept 3
An evaluation should use test evidence and propose a specific correction for any unmet requirement.
Exam cue: Separate accurate output from convenient or attractive presentation.
Risk pitfalls and guardrails
Declaring a database accurate because the SQL executes.
Guardrail: Check route, scope, data type, boundary, loop condition, identifier and expected output before committing to the response.
Evaluating appearance when the criterion is output accuracy.
Guardrail: Check route, scope, data type, boundary, loop condition, identifier and expected output before committing to the response.
Proposing a generic improvement with no link to the failed requirement.
Guardrail: Check route, scope, data type, boundary, loop condition, identifier and expected output before committing to the response.
Memory anchors
Database fitness for purpose
The implemented solution satisfies the required user tasks and outputs.
Output accuracy
Returned records, values, calculations, groups and ordering match the intended result.
Evidence source
Use test results and requirement traceability rather than unsupported opinion.
Relationship error
Incorrect keys or joins can duplicate, omit or mismatch output rows.
Criteria error
Incorrect selection conditions return too many, too few or the wrong records.
Evaluation chain
Requirement + evidence + judgement + specific improvement.
Checkpoint rule
Do the check-up only after you can summarize each concept in one sentence and identify one dangerous pitfall from memory.
Knowledge Check (after reading)
Short check-up to confirm understanding of this module.
Check-up Questions
A database returns every required report with the correct records. What is most directly supported?
A query omits customers whose town field is null even though the report should include them. Which quality is affected?
Answer all questions to submit.
Next step personalized recommendations
Continue learning
Move forward only after this module is stable.
What is Pass Harbor?
Completely free exam prep for 247 UK exams.
- Practice questions
- Flashcards
- Study guides
- Mock exams
- No registration
- No paywall
- Start instantly
“No more expensive exam prep. Quality study tools should be accessible to everyone.”