Database Flashcards
database
A persistent collection of data which is held together in an organised or logical way
field
A single item of data about a person or thing e.g. name date of birth length
record
A set of fields defined to contain information about one thing. e.g. an employee.
table
All of the records regarding a set of people or things
foreign key
An attribute in one table that is a primary key in another table.
data type
Indicates the type of data that can be stored in the field
verification
User process of checking that the data entered is accurate
Length check
Validation technique. Ensures the exact right amount of characters is entered into a field
Range check
Validation technique. Ensures a field is between a certain range of values
Format check
Validation technique. A field may required letters and numbers in a certain order
Presence check
Validation technique. Requires a field to be completed
Lookup table
Validation technique. Only data contained within the lookup table (list) is permitted
Double entry
Verification technique. Two users enter the same data it is then compared for accuracy. Errors are re-entered
Proofreading
Verification technique. Someone checking the data entered against the original document
Query
A database object which enables you to locate multiple records matching specified criteria