How data integrity can be tested in database testing?

1.	How data integrity can be tested in database testing?
Answer» Check in the COLUMN of the database if there is any invalid data. Try to enter the wrong data into the table, and notice how the insertion behaves. Check if, in the reference tables, triggers are working fine. Check the actual result in the main table, when you insert the child record before inserting the parent record. What would HAPPEN if a user delete records derived from another table? Check if the data in two or more REPLICATED SERVERS are in SYNC.

Discussion