Maintaining Data

What are the types of validity checks?

Check Digit 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

Completeness Check verifies that a required field contains data

Consistency Check tests for logical relationship between two or more fields

Range Check determines whether number is within specified range