Year 5 Flat-File Databases

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.

• 
• 
• 
• 
•