Database Fitness and Accuracy
Evaluate a database solution for fitness for purpose and accuracy of output.
How to study National 5 Computing Science
Move from functional requirements to designs and implementation, trace data and code carefully, and support testing and evaluation with evidence.
Core concepts
Concept 1
Fitness for purpose is measured against the database’s functional requirements.
Exam cue: Name the requirement and the evidence that it is or is not satisfied.
Concept 2
Accuracy of output concerns whether a query returns the correct records, fields, values and order.
Exam cue: Separate accurate output from a visually attractive presentation.
Concept 3
A supported judgement cites design, implementation or test evidence.
Risk pitfalls and guardrails
Saying the database is accurate only because the SQL ran.
Guardrail: Check option route, data type, valid boundary, loop condition, array index, identifier and expected output before committing to the response.
Giving an improvement without identifying the current weakness.
Guardrail: Check option route, data type, valid boundary, loop condition, array index, identifier and expected output before committing to the response.
Memory anchors
Database fitness
The solution supports the end-user’s stated functional requirements.
Output accuracy
The correct records, fields, values and sort order are returned.
Evidence
Use a requirement, query result or stored-data check to support the judgement.
Incorrect inclusion
A row that does not satisfy the criterion must not appear.
Incorrect omission
A qualifying row must not be left out.
Evaluation form
Criterion + evidence + effect + justified 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 query returns correct rows in the wrong order. Which criterion failed?
A joined query duplicates each order four times. What should evaluation identify?
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.”