Database Summative assessment

Computer databases allow us to organise,_________, and sort data.

• Measure

• Search

• Field

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

• 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

Answer explanation

The correct answer is C. There are records for Turkey, France, Spain, Japan, and Germany.

Here is the table 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

Answer explanation

The correct answer is D. Choosing A or B indicates a lack of understanding of which fields are needed in this search, and choosing C indicates a lack of understanding about the difference between ‘AND’ and ‘OR’ searches. ‘Or’ would return just the men with an age under ten whereas ‘And’ would return all male passengers and all those under the age of ten.