Databases - Introduction

Question 1

What is a database?

Answer 1

A package for storing information. (All information held is called a file)

Question 2

What is a record?

Answer 2

The information held about one person/object

Question 3

What is a field?

Answer 3

The information on one category

Question 4

Why would you add another record or field? (2)

Answer 4

• If more items are to be included on the database

* If more categories of information are to be added to the database

Question 5

What are advantages of using computer databases? (3)

Answer 5

Less physical space is taken up, can find/sort information quickly and it is easy to edit information

Question 6

What is validation?

Answer 6

The process of checking that data entered is of the correct type and structure

Question 7

What is Presence Check?

Answer 7

Checks fields are not blank

Question 8

What is Restricted Choice?

Answer 8

Gives user a choice such as a drop down menu

Question 9

What is Field Length Check?

Answer 9

Specifies size of a field

Question 10

What is Field Range Check?

Answer 10

Specifies range of numbers a field can hold