Database Analysis
Identify the end users and functional requirements of a relational-database problem.
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
End users are the people or roles that enter, maintain, search or use database output.
Exam cue: Name the user role and the task that role needs to complete.
Concept 2
Functional requirements describe the data and operations the finished solution must support.
Exam cue: Express a functional requirement with an action and the required data or result.
Concept 3
Requirements should be specific enough to trace into entities, attributes, validation, queries and outputs.
Exam cue: Avoid designing tables before the information and operations are understood.
Risk pitfalls and guardrails
Naming a software product as the end user.
Guardrail: Check route, scope, data type, boundary, loop condition, identifier and expected output before committing to the response.
Listing a broad organisational goal instead of database behaviour.
Guardrail: Check route, scope, data type, boundary, loop condition, identifier and expected output before committing to the response.
Confusing a data field with a complete functional requirement.
Guardrail: Check route, scope, data type, boundary, loop condition, identifier and expected output before committing to the response.
Memory anchors
Database end user
A person or role that enters, maintains, queries or uses database information.
Functional requirement
A specific operation or output the database solution must provide.
Data requirement
The information that must be stored to support the required operations.
Traceability
Each requirement should connect to a design feature, query or output.
Requirement wording
User role + required action + data or result.
Analysis boundary
State what the database must do before deciding exactly how tables and SQL will implement it.
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 sports club wants a database. Which statement is an end-user requirement?
Which is a functional requirement for a library database?
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.”