Contact at mumbai.academics@gmail.com or 8097636691
Responsive Ads Here

Thursday, 2 August 2018

Database Testing – Data Integrity

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.

No comments:

Post a Comment