Database basics for key stage 3

What are databases mainly used for?

• To store archived data

• To store and organise data

• To analyse data

Which of the following statements best defines the word 'database'?

• A database is a collection of data or information which is stored in a logical and structured way

• A database is a collection of statistics stored only for computers.

• A database does not collect data or information.

Which of the following uses paper-based databases?

• Phonebook

• Smart Phone

• Computer

Why would you create a primary key?

• To make each record in a database unique

• To make each field in a database unique

• To make each query in a database unique

Select one 'school/student based' database term.

• Allergies

• Type of pet

• Social media accounts

Which of the following defines the term 'field' in relation to databases?

• A field is all of the information about one person or one thing

• A field is the collection of all the database records on one topic or subject

• A field is one type or piece of information

Select the computer-based database

• Phonebook

• Chalkboard

• Google search engine

A sports club needs to store information about each member.  The individual information about each member is called a:

• Field
• File
• Table
• Record

One of the members of the Sports Club has decided to resign.  What would the secretary do with the record for that member on the database?

• Amend the record
• Delete the field
• Delete the record
• Delete the file

The Sports Club has had an Open Day and has gained a new member.  How will they add their details to the database?

• Add another field
• Amend a record
• Add a new record
• Delete a record