Karteikarten
Data validation: checks and errors in data entry
Karten in diesem Stapel (5)
- 1It is important that DATA entered into the computer is accurate. Explain 2 consequences of processing inaccurate DATA.- Incorrect decision being made resulting in loss of money, goods being sent to the wrong address, people being refused credit etc.
- Loss of goodwill and trust from other companies and customers.
- Wasting time having to sort out the mistakes.
Prosecuted under the data protection act 1998 for not keeping accurate personal data records. - 2In a database system a user has to input data into certain fields using a keyboard. Give 3 different types of errors the user could make.- Transcription error
- Transposition error
- Input error
- Processing error - 3A person's date of birth is entered into a database. State and describe 2 things the validation program could check regarding this date as part of validation.- Format Check - dd/mm/yyyy
- Presence Check - check that it has been entered
- Range Check - in between certain range of numbers and that it is valid. - 4Describe what a range check is in terms of data validation. Give an example.Data validation technique which checks that the data input to a computer is within a certain range. Example would be checking the d.o.b of a year 9 pupil. If there d.o.b is lower than 1998, the system wouldn't allow that person to enter that date as they are too old for year 9.
- 5Describe what a presence check is in terms of data validation. Give an example.It is used to check is entered into the correct fields. For example, entering your username and password on Facebook.
Informationen
- Beschreibung
- Karteikarten am Ohne Titel, erstellt von Kirstie Farley am 17/09/2014.
- Erstellt von
- Kirstie Farley
- Aufrufe
- 6
- Bewertung
Mehr zu Data Validation and Verification