Computer Science

a data structure that stores related fields of data for a single object or being

the part of a record which are the category headings for data in a table sometimes called an attribute

an attribute that uniquely identifies a record in a database table

an attribute in one table that is the primary key in another table and is used to link the tables together

Database fundamentals

Database design

SQL fundamentals

SQL searches

Data management with SQL statements

Data protection, copyright and the law

Data and privacy

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 term for a field that uniquely identifies each record in a table?

What do we call a field in one table that links to the primary key in another table?

It reduces duplication and links data efficiently.

What is the main advantage of using a relational database over a flat file database?

“Student ID” in a second table (linking between tables)

Match each example to the correct database concept:

each record links to only one in the other table

one record links to several in the other table

records in both tables link to several in the other, via a join table

Match each type of relationship to its correct description:

Which of the following best describes a database?

a set of rows and columns for storing data

What is a table in the context of databases?

What is the process of arranging data alphabetically or numerically called?

What do we call all the details about one person or item in a table?

If you wanted to find all students with a grade above 80, what feature would you use?

Arrange these steps in the correct order for finding the desired results:

Database fundamentals

Lesson outcome