10. Summary features of validation

  • Validation and verification are useful to provide confidence in the data
  • Validation aims to make sure that the data is sensible, reasonable, complete and within acceptable limits
  • Range checks test if the input data is within a reasonable range
  • Type checks ensure that the data is of the correct type i.e. number vs string
  • Lookups can be used to pre-fix the possible inputs
  • Type-patterns can be used to force the right data type within the data item
  • All this validation does NOT mean the data is correct. It just means it fits a sensible and likely set of rules for each input.

 

 

Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: validating database data

 

Copyright © www.teach-ict.com