Keywords 14 - Databases

Question 1

Data

Answer 1

Raw facts and figures

Question 2

Table

Answer 2

A structure in which data is stored in a database

Question 3

Flat file database

Answer 3

A database whose records are stored in one table only

Question 4

Record

Answer 4

A collection of data about one single item in a database

Question 5

Field

Answer 5

One piece of data about an item in a database

Question 6

Data type

Answer 6

The format of a piece of data in a database e.g. Text, Date/Time, Integer, Real, Boolean

Question 7

Primary key

Answer 7

The unique identifier for each record in a database

Question 8

Index

Answer 8

A list of values or terms

Question 9

Relational database

Answer 9

A database that has several tables linked by primary key fields

Question 10

Foreign key

Answer 10

A primary key that appears in another table in a relation database and forms the unique link between two tables

Question 11

Query

Answer 11

A method of searching a database

Question 12

SQL (Structured Query Language)

Answer 12

A programming language used for maintaining databases and generating queries

Question 13

Query-by-example

Answer 13

A method of searching a database by stating the criteria to be searched

Question 14

Data validation

Answer 14

The process of checking that data input is reasonable

Question 15

Data verification

Answer 15

The process of checking that data input is correct. This is comparatively rare, but is usually done by double entry.