Databases

Question 1

what is a database?

Answer 1

In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage

Question 2

Field length check

Answer 2

only allows a specific number of characters to be entered.

Question 3

Range check

Answer 3

number entered must be within a certain range, eg between 1-100.

Question 4

List check

Answer 4

only specific data can be entered, eg male or female.

Question 5

Present check

Answer 5

the field cannot be left empty.

Question 6

Input mask

Answer 6

data must be entered in a specific way, eg including a space between the first and last part of a postcode.

Question 7

table

Answer 7

A table is a collection of related data held in a table format within a database.It includes fields and records

Question 8

Record

Answer 8

A record is all of the data or information about one person or one thing.

Question 9

Field

Answer 9

a ‘field’ is one piece of data or information about a person or thing.

Question 10

Foreign key

Answer 10

A foreign key is used to link tables together and create a relationship. It is a field in one table that is linked to the primary key in another table.

Question 11

Referential integrity

Answer 11

Referential integrity uses these to ensure that there are no orphan records i.e. it prevents you from deleting related records.

Referential integrity can also alert you if you try to delete a record which is related to another one.

It can also be used to cascade changes made to the database.

Question 12

Reports

Answer 12

Reports present data clearly, so that they are easy to read.

Question 13

Forms

Answer 13

Forms make entering data into a database simple.