Unit 2 Database Development
Relational design, one-to-one and one-to-many relationships, complex queries, SQL, reports, mail merge, macros, redundancy and integrity.
How to study for CCEA GCSE Digital Technology
Connect precise digital concepts to scenario evidence, design decisions, testing and evaluation, then rehearse the controlled-practice lifecycle under your centre's current CCEA instructions.
Core concepts
Concept 1
Relational design separates data into linked tables to reduce unnecessary duplication and protect integrity.
Exam cue: Choose relationship cardinality from how many records can validly match.
Concept 2
Complex queries combine criteria, calculation, selection and sorting; basic SELECT, FROM and WHERE statements express retrieval logic.
Exam cue: Translate the request into SELECT fields, FROM source and WHERE conditions.
Concept 3
Reports, mail merge and macros turn stored data into controlled outputs or automated workflows.
Exam cue: Explain how a design change reduces redundancy without losing required links.
Risk pitfalls and guardrails
Creating duplicate tables instead of a relationship.
Guardrail: Keep to Northern Ireland CCEA scope, never add the weights of both routes, and distinguish a digital concept from unsupported product or technology claims.
Confusing a calculated query with permanently stored duplicated data.
Guardrail: Keep to Northern Ireland CCEA scope, never add the weights of both routes, and distinguish a digital concept from unsupported product or technology claims.
Claiming normalised structure alone guarantees accurate input.
Guardrail: Keep to Northern Ireland CCEA scope, never add the weights of both routes, and distinguish a digital concept from unsupported product or technology claims.
Memory anchors
Relational database
Data held in linked tables connected by matching keys.
One-to-many
One record in one table can relate to several records in another.
SQL SELECT
The clause naming fields or expressions to return.
SQL FROM
The clause naming the table or data source.
SQL WHERE
The clause restricting returned records by criteria.
Data integrity
The accuracy, consistency and validity of stored relationships and values.
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
[Multimedia route] Why split Customers and Orders into related tables?
Which relationship fits one author writing many books, with one author per book?
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.”