Database - Year 7

What is a database?

• A device to load information onto the computer.

• A piece of software to do calculations

• A calculator

• A structured collection of information

The whole database is called:

• The file

• The field

• The table

• The record

IKEA stores details of its stock on a relational database. Along with a unique stock code, all items are stored in coded aisles eg. BLU24, ORS23, YEL49 etc. What type of validation would be used on this aisle code?

• Presence

• Length

• Field

• Range

The school wants to sort the data by staff Surname. How will they sort it?

• Ascending order

• Descending order

A film club stores details of all the films it shows. One of the fields is Genre (sample data: Action, Horror, Family, Fiction etc). What validation would be most suitable for this field?

• Range

• Presence

• Restricted Choice

• Length

The health club stores the ages of its members. What validation check would be used on the age field?

• Length

• Presence

• Restricted choice

• Range

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

• Delete a record

• Add another field

• Add a new record

• Amend a record

A Gym has a database with all their members they want to include email addresses in the database, what will they do?

• Add a record

• Edit a record

• Add a field

• Delete a field

One specific piece of information about a person or thing is called:

• File

• Field

• Table

• Record

Which of the following describes a relational databse?

• There are two or more tables that are linked using the primary keys

• Access

• A database that has a table

• There are more than one table that have duplicate data