What is validating data
When you think of data validation, what's the first thing that comes to your mind?
Is it, by any chance, to enter numbers when an application is expecting numbers out of you, the user?
For example, a student's age might be 14, but if 11 is entered it will be valid but incorrect.
There's more to data validation that simply validating the data, alot more as you'll see there is alot of things that can be done to help in the data validation process.
In this document, we will cover all you'll ever need to know about data validation, what it really means, how to use it effectively and ultimately how to minimize the use of data validation while still assuring that the data is indeed valid. Data validation, as explained above, is making sure that all data (whether user input variables, read from file or read from a database) are valid for their intended data types and stay valid throughout the application that is driving this data.
If the initial data ends up being wrong, can you imagine just how bad the amortization table would end up being at the end of the calculation?
Don't you think that the entry screen should be 100% sure of it's data before it goes ahead and performs the generation of the amortization table?