Mindmap
Validating data
Inhalt der Mindmap
Validating data
Range check
- You have a min and max, for example the min might be 0 and the max might be 10. Range checks will check if the minimum or max requirments.
- A range check will help maintain a the integrity of a database because it checks to see if the data entered has met the minimum requirements and so that it does not exceed the maximum requirements.
Length check
- Length check will check the amount of characters and try to keep it within the limit that was set. This is so you will be able to save memory. So space isn't wasted.
- A length check will help maintain the integrity of a data base because it will check to see if the characters entered are within the limit set. This allows for a database to save memory and sort data more efficiently.
Presence check
- They check to see if there is something in that field to stop people from not entering the correct data. To maintain the integrity of the data base
Type check
- To check if the correct type of data has been entered, for example it checks to see if only integers are entered rather than just characters.
Format check
- It checks if it is the correct format, for example your postcode, as it will check for 4 in the first part and 3 in the last.
Spelling
- It will check to see if the data entered is the correct spelling, it will check it against the English ( or whatever language you're using) dictionary to see if the data entered is correct.
- This helps maintains the integrity of database because it will stop from errors being entered into a database by showing all the mistakes the user has entered.
Check digit
- It runs an algorithm to check if the digit entered are correct and valid, it checks if its in a certain range, the each digits entered.
why do we validate data? So we can have accurate and robust data integrity
Error handling
- On screen error message
- Tells users what they done wrong and what they can do to fix it
- log
- Records error in a log the company can access that log and fix them errors.
- Reporting
- Send the error report to the company so that they can fix.
- You need to make your code robust by including lines of code that will allow the program to continue, should an error be encountered. for example the try option in python.
- On screen error message
Informationen
- Beschreibung
- BTEC Computing Mindmap am Validating data, erstellt von Colby Smith am 17/03/2017.
- Erstellt von
- Colby Smith
- Aufrufe
- 1
- Bewertung
Mehr zu Data Validation and Verification