Database essentials
Lesson details
Key learning points
- 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](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707171320%2Flgkxh1k9djzyzoavmylz.png&w=828&q=75)
Primary key
Record
Table
Q2.
Which of the following terms matches what is being highlighted at position c?
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707171336%2Fqpudyqad7uw60pf49yqp.png&w=828&q=75)
Fields
Primary key
Table
Q3.
Which of these statements best describes a flat file database.
A database that doesn’t have a primary key
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.
A primary key must always be a number
The same primary key can be used for multiple entries