Organisation of Data Flashcards
Field
Part of record designed to hold a single data item of a specified type
Record
Collection of items (may be of differing data types) relating to an individual or object
Master file
The principal source of data for an application Semi permanent file which contains some data that may change whenever a transaction
occurs
Transaction file
data file in which transaction records that relate to entries in a master file are stored
Data validation
A check made by the program to ensure the data entered is reasonable
Range Check
The computer checks that data must be a value that falls between two predefined values
Presence Check
The computer checks that a value must be entered,
Format Check
The computer checks that the data must conform to a prescribed layout (specific numbers or letters)
Data Type
The computer checks that the data must be of a specific type (number, text, Boolean, etc.)
Fixed Value / Drop
down
The computer checks that the data must conform to one of the values in a predefined list
Data verification
Checking transferred data by comparing copies of the data before and after transfer to ensure the data are accurate.
Double Entry
Normally the user will have to type in twice. Both entries are compared
Proof reading
Read before you submit to compare both
Serial file
A file that contains data collected in consecutive manner in no particular order (e.g. cashpoint transactions)
Sequential file
A file that contains data or records are stored, one after another, in a defined order ( e.g. Class register by surname)
