Database Basics

primary key

The unique identifying value for records in a database.

data

Units of information. In computing there can be different data types, including integers, characters and Boolean. Data is often acted on by instructions.

database

A data store designed in an organised way, making it easier to search for the information you need.

foreign key

A link to a primary key in a relational database table.

query

A search or question performed inside a database.

record

All of the data relating to one person or thing in a database.

field

An element of a database record in which one piece of information is stored. For example 'name' in an electronic address book.

validation

Checking input data is sensible and in the right format.

field type

Describes the kind of data that will be stored in that field. Choices might be alphanumeric, currency, date, or Boolean.

report

Exported data presented in a clear and readable form.