WorksheetsFlat-File Databases
Total questions: 20
Worksheet time: 20mins
Which of these are features of a flat-file database? A flat-file database:
(Tick all that apply)
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
Length
Diet
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 highlighted places?’
Boarded = Belfast or Boarded = Queenstown
Age = 10 and Boarded = Belfast
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 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?
Table View
Chart View
What is a flat file database?
Contains a single table
Two or more linked tables
Used to create formula's
A field is...
A specific item of data stored for each record
All the information about one object in the database
The whole database
Who might use a database?
School
Police
Employer
All of the above
Short text, date, long text and number are all examples of what?
Data types
Headings
Fields
Records
What is an advanage of a database?
You can input information
Its different to Excel
It saves files
Can search through and find information quickly
Which of the following uses paper-based databases?
Phonebook
Smart Phone
Computer
