Flat file databases

Which of these are features of a flat-file database? A flat-file database:

• Retrieves its data from the internet

• Is a collection of organised data

• Is a collection of tables that contain data

• Can be used to search and sort a dataset

• Is stored on a computer

Which of these are examples of database fields? (tick 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 column 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 underlined places?’

• Age = 10 and Boarded = Belfast

• Boarded = Belfast or Boarded = Queenstown

• Boarded = Queenstown or Age = 10

• Boarded = Queenstown and Boarded = Belfast