Whenever there are different modules in the application that are using the same DATA and also perform different operations on them, it is very much necessary to have the latest data to be shown everywhere. The most recent value of the data should be used by the systems. This is called Data Integrity. Following image shows 5 characteristics of data following data integrity:

We can apply the following test cases for TESTING out the integrity of the data:

• Are all the triggers working FINE to update the records in the reference tables?
• Are there any invalid data in the columns of each database?
• INSERT wrong data into the tables and see how the insertion behaves.
• What would happen if you try to insert the child record before inserting the parent record in the MAIN table?
• Is there any failure if you are trying to delete records referenced by another table?
• Are the replicated servers in sync? The data should not be out of sync in two or more replicated servers as it would defy the intent of replication.