Data Validation Flashcards
all about data validation
What is data validation
Data validation is the process of ensuring that data entered into a system meets certain criteria for accuracy, completeness, and consistency
Range check
Ensures that values fall within a specified range
Type check
Ensures that data is of the correct type, such as alphabetic or numeric
Presence check
Prevents essential fields from being blank
Uniqueness check
Ensures that there is no duplication or overlap
Check digit
Ensures that code numbers that are originally produced by a computer are re-entered into another computer correctly.
Length check
Confirms that a data entry has the correct length.
Consistency check
Filters out bad data to ensure high-quality data for proper analysis.
difference between data validation and data verification
data validation ensures that data meets predefined criteria for quality and consistency, while data verification confirms the accuracy and correctness of the entered data through various methods.