Year 11
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
- 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?
Level
Sessions
Start_Date
Q2.
What are the relationships between the tables?
Many 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
4