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.