UK GDPR, Relationships, Dictionaries and Queries
Apply UK GDPR principles and design two related entities, their data dictionaries and multi-table query requirements.
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
Required UK GDPR principles cover lawful, fair and transparent processing, purpose limitation, data minimisation, accuracy, retention and security.
Exam cue: Place the foreign key on the many side and link it to the one side’s primary key.
Concept 2
A two-entity diagram shows entity names, attributes and a one-to-many relationship.
Exam cue: Choose validation from the field’s permitted values, length or numeric range.
Concept 3
A data dictionary records keys, types, size and validation; a query design specifies tables, fields, criteria and sort order.
Risk pitfalls and guardrails
Treating validation as proof that stored facts are true.
Guardrail: Check option route, data type, valid boundary, loop condition, array index, identifier and expected output before committing to the response.
Placing repeated group data in the one-side entity.
Guardrail: Check option route, data type, valid boundary, loop condition, array index, identifier and expected output before committing to the response.
Memory anchors
UK GDPR core
Process data lawfully, fairly, transparently and only for the declared purpose.
Data discipline
Keep only needed, accurate data, retain it no longer than necessary and hold it securely.
One-to-many
One record on the parent side can relate to many records on the child side.
Primary key
An attribute that uniquely identifies each record in its entity.
Foreign key
An attribute that stores the related parent record’s primary-key value.
Data dictionary
Record entity, attribute, key, type, size and validation details.
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 company uses competition emails for unrelated marketing without explaining this. Which principle is most directly involved?
A database keeps former applicants' details indefinitely without need. Which principle applies?
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.”