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?
Correct answer: Fields
Primary key
Record
Table
Q2.
Which of the following terms matches what is being highlighted at position c?
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

Lesson appears in

UnitComputing / Databases and SQL

Computing