Swim challenge (Part 1)
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?
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707159801%2Frrzbpwkjopejha64nagz.png&w=384&q=75)
Level
Sessions
Start_Date
Q2.
What are the relationships between the tables?
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707159803%2Frcaoz2s9gny9r3d09kgu.png&w=1920&q=75)
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)
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707159814%2Ffu6h288cv5tqopbe2wax.png&w=750&q=75)
1
2
4