Year 11
Year 11
Swim challenge (Part 1)
Link copied to clipboard
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.
These resources were created for remote use during the pandemic and are not designed for classroom teaching.
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