Database

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

What is open data?

• Open data is data that only certain people have access to

• Open data is data that is freely available and shared

• Open data is data that is very secure

What is the difference between an entity and an attribute?

• An attribute is a table in a database and an entity is a field

• An attribute is a record in a database and an entity is a table

• An attribute is a field in a database and an entity is a table

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

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

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

• A file is one type or piece of information

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

Select the computer-based database

• Phonebook

• Chalkboard

• Google search engine