Year 11 - Computing
Data protection, copyright and the law
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 describe key UK computer laws and explain how they protect data, creative work and software use.
Key Notes
- Databases are designed to store large volumes of data.
- This data could hold sensitive and personal information about individuals and needs to be protected.
- In the UK there are a number of laws which protect data, including GDPR and The Data Protection Act.
- Software can be categorised as open source or proprietary.
Vocabulary To Learn
- patent: a legal right that gives an inventor the exclusive right to make, use or sell their invention for a certain number of years
- open source: software for which the program source code is made available to the general public
- proprietary: software that is owned by a company or person. You are not allowed to change, copy or share it without permission. Sometimes called closed source software
Common Mistakes To Avoid
- Proprietary software always costs money.
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 and needs to be protected.
2. Define this computing term and give one practical example. 'patent'
a legal right that gives an inventor the exclusive right to make, use or sell their invention for a certain number of years. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Proprietary software always costs money. Correction: Proprietary software is usually sold to end users, although sometimes it is available for free.
More Lessons In This Unit
Browse all guides in the Year 11 Computing guide library.