Font size
WorksheetsYear 5 Flat-File Databases
Total questions: 10
Worksheet time: 50mins
Computer databases allow us to organise, __________, and sort data.
measure
search
field
Which of these are examples of database fields? (Select all that apply)
1st
Age
Mr
Class
How many records can you see in this database?
6
30
5
15
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?
Name
Diet
Length
12
Which field has this data been sorted by?
Surname
Class
Boarded
Age
What would you search for to answer this question: ‘How many males under ten years old were on board the Titanic?’
Name and age
Gender and class
Gender or age
Gender and age
The Titanic picked up passengers from:
● Southampton
● Cherbourg
● Queenstown
● Belfast
What would you search for to answer this question: ‘Altogether, how many people boarded at the highlighted places?’
Age = 1- and Boarded = Belfast
Boarded - Belfast or Board = Queenstown
Boarded = Queenstown or Age = 10
Boarded = Queenstown and Boarded = Belfast
Which two fields have been used to create this graph?
Population and country name
Country name and area
Area and currency
Currency and population
The following two views can be seen when using a database: ‘table view’ and ‘chart view’. If I wanted to know which two of the countries listed had the largest population, which view would be the most useful? Select the correct view
This is a website for a shop called Thames Online. This website uses a database to store the information it needs. Select three fields that you can see in this image.
