Help shape GoConqr. What should we add next?

Mind map

Data Validation

moulti English

Map content

Data Validation

  1. Data Validation is an automatic computer check to ensure that the data entered is sensible and reasonable

    • It does not check the accuracy of data
  2. Range Check

    • For example, a secondary student is likely to be aged around 11-16
      • The computer can be programmed to only accept numbers between 11-16
        • However this does not guarantee that the data entered is correct
  3. Types of validation

    • Check digit
      • The last one or two digits in a code are used check the other digits are correct
        • Eg. Bar code readers in supermarkets use check digits
    • Format check
      • Checks the data is in the right format
        • Eg. A National Insurance number is in the form LL 99 99 99 L where L is any letter and 9 is any number
    • Length check
      • Checks the data isn't too long or too short
        • Eg. A password needs to be 6 letters long
    • Lookup table
      • Looks up acceptable values in a table
        • Eg. There are only 7 possible days of the week
    • Presence check
      • Checks that data has been entered into a field
        • Eg. In most databases a key field cannot be left blank
    • Range check
      • Checks that a value falls within the specific range
        • Eg. Number of hours worked must be less then 50 but more than 0
    • Spell check
      • Looks up words in a dictionary
        • Eg. When word processing

Information

Description
Mind Map on Data Validation, created by moulti on 09/04/2016.
Created by
moulti
Views
2
Rating

More on Data Validation and Verification

Feedback

What is it about?

What should we add next?