Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data (Data And Data Types (Data Types (Alphanumeric (Alphanumeric is any…
Data
Data And Data Types
Data
Data is raw facts and figures before they have been processed.
Data can be made up of letters, numbers, symbols, graphic and sound.
Data Has no meaning.
-
Data Types
Alphanumeric
Alphanumeric is any combination of letters, symbols, spaces or numbers.
Example of data is - AjcY68&9£4
It Can be used to store postcodes, as these contain letters + Numbers
Integer Numbers
Integer numbers are full/whole numbers.
Example of data - 1976
It can be used to store number of items in stock, Number of lengths swum, number of tickets sold
Real Numbers
Real numbers are any numbers with or without decimal places
Example of data - 12,30
it can be used to store height/weight
Currency
Currency shows data in a format of money. It can be used to show currency signs (E.g. £ or $) and have decimal places to show the full details.
Example of data - £66.66 or $66.66
It can be used to store prices
Percentage
A number format that includes decimal places and a % sign.
Example of data - 25%
To show a percentage of a discount,
E.g. 25% off the price
Text
Text includes Letters and numbers only. Example of data - Bailley it can be used to store Names of individuals and places and used to show a phone number
-
Limited choice
Gives the user limited options
Example of data - Miss,Mrs,Mr,Sir
Date/time
Used to display a date or time.
Example of Data - 12/02/2020
Can be used to display an individuals Birthday,Day of death,appointment date or time.
-
Big Data
Big data is large, complex sets of data that cannot be analysed with traditional data processing software.When big data is analysed it can be used to identify,trends
-
databases
-
Database
Disadvantages
-
-
-
Database Can Be Hacked,exposing data
Advantages :
-
Records are stored safely, they are available when needed
-
-
-
-
-
-
-
Data Validation
Types
-
-
-
Range Check
Check if data is between lower and upper range
E.g. 1-10 (5 would be accepted, 11 would be rejected)
Lookup Check
When you look for a match on a key field,to ensure the data entered is more accurate
E.g. Address to find postcode
The checking of data by software on entry to see if it is reasonable / sensible (IT DOES NOT CHECK ACCURACY)
Verification
Types
To check is data entered matches the original source EXACTLY. (The process of checking a copy of a data to ensure that is exactly the same as the original data).
-
Proof reading
This is where someone checks the data against the original source
E.G. Checking parent details against the data capture forms you guys made