Unit 1 Database Applications
Tables, records, fields, keys, queries, forms, reports, relationships, validation, logical operators, big data and analytics.
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
A database structure organises related fields into records and tables, using keys and relationships to identify and connect data.
Exam cue: Translate a user request into fields, types, keys and query criteria.
Concept 2
Validation checks whether input follows defined rules, while a query applies criteria and logical operators to retrieve required records.
Exam cue: Separate validation from verification and from whether a value is factually true.
Concept 3
Big data is characterised by volume, velocity and variety, and analytics turns it into evidence for decisions.
Exam cue: Use AND where all conditions must hold and OR where any named condition can hold.
Risk pitfalls and guardrails
Assuming validation guarantees accurate or truthful 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.
Choosing a non-unique field as a primary key.
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.
Reversing AND and OR in a multi-criterion query.
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
Record
All stored fields describing one entity instance.
Primary key
A field or combination uniquely identifying each record.
Query
A request that selects or processes records using defined criteria.
Validation
Automatic checking that input meets preset rules.
Relationship
A defined link between matching fields in database tables.
Big data
High-volume, high-velocity and varied data requiring suitable analytics.
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
What is a field in a database table?
What is a record?
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.”