Computer Science

the process of removing or changing personal information in a dataset so that individuals can no longer be identified

the right to keep your personal life private

Data and privacy

Database fundamentals

Database design

SQL fundamentals

SQL searches

Data management with SQL statements

Data protection, copyright and the law

Big data

The environmental impact of data systems

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.

Databases and SQL

What is the main reason databases need privacy measures?

Which of these is a method to protect data in a database?

What is the process called that scrambles data so only authorised users can read it?

What is the process called that removes or changes personal details in data so individuals cannot be identified?

Match each law or act to its correct description:

Data is always safe once stored in a database.

Databases protect data without any extra measures.

Data must be protected with privacy measures, not just stored.

All databases automatically keep data private.

Which statement about storing data in a database is correct?

Which of these is an example of personal information?

What is the main reason personal data needs to be protected?

Which UK law helps protect personal data?

What is the term for software that is owned by a company or person and cannot be changed or shared without permission?

Put these steps in order for creating a new database and protecting the data:

Data and privacy

Lesson outcome