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.