warning

These resources will be removed by end of Summer Term 2025.

Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.

Lesson details

Key learning points

  1. In this lesson, we will explore the key terminology required to be able to use SQL to search and update a relational database. Together we will step through the key concepts using a music database as an example. We will complete the lesson by gaining some hands on experience of using a database management system.

Licence

This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.

Loading...

4 Questions

Q1.
Which of the following terms matches what is being highlighted at position B?
An image in a quiz
Correct answer: Fields
Primary key
Record
Table
Q2.
Which of the following terms matches what is being highlighted at position c?
An image in a quiz
Fields
Primary key
Correct answer: Record
Table
Q3.
Which of these statements best describes a flat file database.
A database that doesn’t have a primary key
Correct answer: A database that has a single table
A database that has multiple tables
A database with a limited number of fields
Q4.
Which two of the following are properties of a primary key.
Correct answer: A primary key allows you to identify each unique record
A primary key must always be a number
Correct answer: Each value held must be unique
The same primary key can be used for multiple entries