14.07 Data Validation Flashcards
Why is data validation necessary?
Because data could easily be entered incorrectly, eg a name being entered with a mistake, then when a query is made using the name spelt correctly, the needed data would not show up. The database is only reliable if the data is entered correctly when the database when created/information was added.
What is data validation?
The process of of automatically checking whether the data entered is valid, ie not erroneous etc, however it doesn’t mean the data is correct, ie entering the wrong name spelt correctly.
How does data validation work?
It checks that the data entered complies with certain rules depending on the record and field it is entered into. For example in a field for test results as a percentage, the validation process would check that the data entered is between 0 and 100, and is a number etc, it would not detect the number 55.555555 being entered, but it still helps with eliminating incorrect results.