Computer Science

data that is too large and complex to be dealt with by traditional processing methods and systems

the total amount of data stored, processed, and transmitted, typically measured in bytes

the diverse range of data types and formats

the speed at which data is created, processed, and analysed

Big data

Database fundamentals

Database design

SQL fundamentals

SQL searches

Data management with SQL statements

Data protection, copyright and the law

Data and privacy

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

data too large and complex for traditional systems

Which of the following is NOT one of the 3 Vs of big data?

Put these steps in order for handling big data:

They are slower than traditional systems.

They offer more storage and processing power.

Why are cloud systems often used for big data?

Big data easily fits into traditional row-and-column databases.

Big data is mostly unstructured and needs special storage solutions.

All big data is stored as handwritten notes.

Big data is too small to need special storage.

Which statement about storing big data is correct?

to store and search large amounts of information easily

Why might a company use a database instead of a paper filing cabinet?

Which of the following is a risk if personal data is not protected in a database?

What is the process called when details that could identify individuals are removed from a dataset?

a check to ensure data is managed correctly

What is a possible consequence for an organisation that breaks data regulations?

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

Big data

Lesson outcome