Database Testing – Data Integrity

Data Integrity is important in a database. It includes data validation before insertion, updates, and deletion. Triggers must be in place to validate reference table records.

For checking Data Integrity, you need to perform the following operations −

• You need to check major columns in each table and verify if any incorrect data exists. (Characters in name field, negative percentage, etc.)

• Find out inconsistent data and insert them into relevant tables and see if any failure occurs.

• Insert a child data before inserting its parent’s data. Try to delete a record that is still referenced by the data in another table.

• If a data in a table is updated, check whether the other relevant data is updated as well. You need to ensure that replicated servers or databases are in sync and contain consistent information.