Consistency
Check
tests for logical relationship between two or more fields
tests for logical relationship between two or more fields
Maintaining Data
p. 525
Next
Click to view Web Link,
click Chapter 10, Click Web Link
from left navigation,
click Chapter 10, Click Web Link
from left navigation,
then click Check Digits
below Chapter 10
below Chapter 10
What are the types of validity checks?
Range
Check
determines
whether
number is within specified range
Completeness
Check
verifies that a required field contains data
verifies that a required field contains data
Check
Digit
number(s) or character(s) appended to or inserted into a primary key value to confirm accuracy of primary key value
number(s) or character(s) appended to or inserted into a primary key value to confirm accuracy of primary key value
Alphabetic/
Numeric Check ensures correct type of data entered
Numeric Check ensures correct type of data entered