data and information - Flat file database

Computer databases allow us to organise, __________, and sort data

• measure

• search

• field

Which of these are examples of database fields?

• 1st

• Age

• Mr

• Class

Answer explanation

The correct answers are B and D. We know this, as they are the fields in ‘record view’ which are presented as headings in the ‘table view’.

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

Answer explanation

The correct answer is D. The other fields which we can see contain mostly the same information, and therefore sorting them would not make any difference.

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 = 10 and boarded = Belfast

• Boarded = Belfast or Boarded = 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

Here are two views which you can see 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?

• A

• B

This is a website for a shop called Thames Online. This website uses a database to store the information it needs. Write three fields that you can see in this image