Data validation
Data Validation
By inputting the data into the computer, the processing is completed and meaningful information is obtained. Results are generated depending on the input data. Inputting wrong data will also result in wrong. Effectively extract data from source documents to ensure authenticity and validity of data. Then the data is properly inputted through data coding and appropriate equipment. But there may be some mistakes, which are not understood beforehand. However, any errors that occur more frequently need to be identified. Data authenticity and validity are generally checked in two ways, namely--
(i) Transaction Validation
ii) Data Validation
Transaction Validation: The validation that is checked on data input is called transaction validation. Usually, such validation is done through software.
Generally, three types of mistakes can occur in this case, namely--
(i) Inputting data
(ii) Data by unspecified persons
(iii) Instructing the system to do wrong. For example, deleting a record by mistake.
Data Validation: It is essential to verify the validity and authenticity of input data to generate effective and meaningful results. First, check the validity and authenticity of the input transaction. The data validation means determining whether the data has been input correctly or not. The main ways of checking the validity and authenticity of data are given below--
(i) Missing Data Test: In this case, it is checked whether data has been omitted by mistake. For example, if a student's roll number is missing in generating student results, the processing result will be invalid. For that, it is necessary to check whether there is any data missing or not before processing.
(ii) Data field length test: In this case, according to the length of the field, it is checked whether the data has been input or not. For example, if every city in Bangladesh is coded with (4) characters, if any city is inputted with 5 characters during typing, the processing result will be invalid.
(iii) Data Classification Test: In this case, it is checked whether there is any numeric data inside a string data and whether there is string data inside numeric data.
(iv) Data Range Test: In this case, the minimum or maximum value of any data is checked. For example, a person cannot be 500 years old or 35 days in January.
(v) Stored Data Test: If a certain type is already stored in the computer, the validity of the data can be verified by comparing it with the newly entered data.
(vi) Check Digit: There may be mistakes while entering any large numeric data such as account number, code number, ISBN number etc. First, by entering many numbers, in the end, if you enter the check digit number, the computer will calculate the numbers based on a certain algorithm and match them with the check digit, and if there is a discrepancy, it will give a wrong signal. As a result, the user can re-enter the numbers correctly. Let's look at the example below to see the use of check digits. A customer's account number is 11377455 (eleven-based check digit).
Comments
Post a Comment