Chapter 11, Problem 7SG

Explanation of Solution

Validation:

Validation is done for comparing data with certain rules to find whether the data meets some criteria.

• It is a process for checking the data whether it make some meaning or not.
• Many programs perform validation at the time of entering the data or on entered data.
• Assume that, there is an admission of new student...

Explanation of Solution

Type of validity checks:

Alphabetic/Numeric Check:

• Alphabetic check ensures the user enters only alphabetic values to the field. For example, in the field of First Name user should only enter the alphabetic character only.
• Numeric checks ensure that user enters only numeric values to the field. For example, in the field of Current Enrollment, user can enter only integer values.

Range check:

• Range check ensures that the user enters a value is within a specified range. For example, assume that the lowest per credit hour fee at the school is $75.00 and the highest is $370.75.
• A range check ensures whether the credit hour fee field value is between $75.00 and $370.75.

Consistency check:

• A consistency check will test the data in one field or two or more fields to ensure that the relationship is logically correct and their data format is correct.
• In this check, it will concentrate to maintain the physical and logical consistency of database.
• For example, the field date of admission of a student in particular institution cannot be earlier in time than the value in student’s date of birth field...