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