Transactions that Distinguish between Integiry and validation!! HELP!! (1 Viewer)

[MiChelle]

Another Question!

This one really confused me, Give an example of a Transaction that distinguishes (notes Differences) between data validity and data integrity..


*Data validity- The checking of the accuracy of the data before it is processed into information.
*Data integrity the reliability of data.

What can some examples be??

 

[gandalf]

I'll have ago ...

Consider the familiar transaction of a can of beans being scanned at the supermarket. The barcode on the can has a series of numbers which represent the product. As the barcode is scanned these number are entered into the system. One of the numbers on the barcode (usually the last number) is a check digit. Some sort of algorithm is applied to all the other numbers on the barcode to yield a single digit the check digit. If the number calculated does not match the check digit scanned into the system (ie the one written on the barcode) then the system knows there was an error in scanning process (maybe the can wasnt at the right angle, or the label is torn) this is DATA VALIDATION (ie accuracy).

Now, once we have a VALID number entered into the system, the database of stock information gets to do something with the number. The first thing it will likely do is check the database to see if the number exists in the stock list. If it does, then it can get a price, if not, then an error will be thrown up (perhaps the person who stocked the shelf didnt enter then number correctly and therefore, according to the system, the can of beans shouldnt exist) this is DATA INTEGRITY.