Year 11 - Computing
Data and privacy
Databases and SQL
Study Hub
Study Guides
This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.
Unit Summary
This unit introduces pupils to databases and SQL, they will explore the key terms used in a database and why relational databases are used to eliminate the redundancy that can occur in a flat file database. They will explore SQL commands to retrieve, update, and delete data in a relational database.
Lesson Summary
You will learn to explain how data privacy is maintained in databases and identify regulations that protect personal information.
Key Notes
- Databases are designed to store large volumes of data.
- This data could hold sensitive and personal information about individuals.
- There are a number of methods that can be used to protect data held in databases.
- These methods include user access controls, data encryption, regular audits and data anonymisation.
- Regulations are laws that tell organisations how they must handle personal data to keep it safe and private.
Vocabulary To Learn
- anonymisation: the process of removing or changing personal information in a dataset so that individuals can no longer be identified
- privacy: the right to keep your personal life private
Common Mistakes To Avoid
- Once data is stored in a database, it's automatically safe and private.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
Databases are designed to store large volumes of data. This data could hold sensitive and personal information about individuals.
2. Define this computing term and give one practical example. 'anonymisation'
the process of removing or changing personal information in a dataset so that individuals can no longer be identified. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Once data is stored in a database, it's automatically safe and private. Correction: Just storing data in a database does not make it secure. Data must be protected with proper privacy measures.
More Lessons In This Unit
Browse all guides in the Year 11 Computing guide library.