Database

What is a database?

• A structured collection of information

• A device to load information onto the computer.

Which of the following describes a relational database?

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

• A database that has a table

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

• Record

• Table

• File

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?

• Delete the record

• Delete the field

• Amend the record

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

• Add a new record

• Delete a record

The whole database is called:

• The File

• The 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

• Add a field

What data type would be used to store the following item code: 0024

• Text

• Real

• Number

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

• Length

• Presence

Random access method is the fastest way of accessing a record

• True

• False