Lesson details

Key learning points

  1. In this lesson, we will use our SQL skills to build, interrogate, and update a database to manage swimming lessons.

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...

3 Questions

Q1.
Which field is the primary key in this table?
Correct answer: CourseID
Level
Sessions
Start_Date
Q2.
What are the relationships between the tables?
Many to Many
Correct answer: One to Many
One to One
Q3.
How many records would the following query find?SELECT * FROM tblCourses WHERE Start_Date = “2020-10-04”; (Image source: DB Browser for SQLite)
1
2
Correct answer: 3
4

Lesson appears in

UnitComputing / Databases and SQL

Computing