Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATA - Coggle Diagram
DATA
Data Types
Alphanumeric
letters, numbers, symbols spaces
Numeric
Decimal
Includes a decimal point
Percentage
Any proportion or share
interger
A whole number
real
expressed as a fraction or decimal
Currency
Type of money
Date
Day/Month/Year
Boolean
True or False
Data Validation
Validation
Type check
Must be set to a set piece of data
Presence check
checks that some data has been entered into the field
Format Check
Data must be set to a format
Limited Choice
used to allow only selections that are given.
Length Check
Restricts how long it can be
Lookup
checks the value that you have entered against an allowed list of values.
Range check
Lower and upper limit (1-100)
Verification
Double entry
Where you enter the data twice to verify it is true
Manual checking
When you go through something and check it