Year 5
Using a database
Lesson details
Key learning points
- In this lesson, we will search and order a database to answer questions.
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 of these are examples of database fields? (tick all that apply)
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707168625%2Fwiwug4iyeqgimeryrcav.png&w=640&q=75)
Brazil
Hindi
Q2.
How many records can you see in this database?
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707168628%2Fzzivron9rnx1hzw7h7sk.png&w=640&q=75)
36
5
8
Q3.
Here is the table view of a database. We want to answer the question: ‘How long is the longest dinosaur?’ Which field would you use to answer it?
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707168657%2Fp8hkbngx5gyqfhray0lk.png&w=750&q=75)
12
Diet
Name
3 Questions
Q1.
Which column has this data been sorted by?
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707156269%2Fdsxu1ismivqvuhlholju.png&w=640&q=75)
Country Name
Currency
Population
Q2.
The data below has been produced by a search. What was searched for?
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707156244%2Fnrfxjyrxu8ko5xweeqpc.png&w=1080&q=75)
Area = 505,990
Currency = Peso
Q3.
By which fields has this data been searched and sorted?
![An image in a quiz](/_next/image?url=https%3A%2F%2Foaknationalacademy-res.cloudinary.com%2Fimage%2Fupload%2Fv1707156257%2For5fs5u1wqqcmck52lv0.png&w=640&q=75)
Currency then Area
Language then Area
Population then currency