Y5 - Data - FlatFile Databases

Name

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

• measure
• search
• field

2. Which of these are examples of database fields? (tick all that apply)

• 1st
• Age
• Mr
• Class

3. How many records can you see in this database?

• A: 6
• B: 30
• C: 5
• D: 15

4. 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?

• A. Name
• B. Diet
• C. Length
• D. 12

5. This table shows passengers boarding the Titanic. Which column has this data been sorted by?

• A. Surname
• B. Class
• C. Boarded
• D. Age

6. What would you search for to answer this question – ‘How many males under thirty years old were on board the Titanic?’

• A. Name and Age
• B. Gender and Class
• C: Gender or Age
• D: Gender and Age

7. The Titanic picked up passengers from: What would you search for to answer this question: ‘Altogether, how many people boarded at the highlighted places?’

• A: Age = 10 and Boarded = Belfast
• B: Boarded = Belfast or Boarded = Queenstown
• C: Boarded = Queenstown or Age = 10
• D: Boarded = Queenstown and Boarded = Belfast

8. Which two fields have been used to create this graph?

• A: Population and country name
• B: Country name and area
• C: Area and currency
• D: Currency and population

9. Here are two views which we 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. Table view
• b. Chart view