Database Integrity is a central underlying aspect or term in the implementation of database technology. Having faith in the data correctness is a prerequisite for using the data in business, research or decision-making applications. So it’s for sure that the factors of ensuring database security and reliability cannot be ignored. One also has to consider the use of error checking and correction codes to deal with the integrity issues and improve the performance of database systems.
Enforcing Data Integrity in Databases
Basically, there are four primary types of data integrity: entity, domain, referential and user-defined.
1. Entity Integrity ensures a table does not have any duplicate rows and is uniquely identified.
2. Domain Integrity requires that a set of data values fall within a specific range (domain) in order to be valid.
3. Referential Integrity is concerned with keeping the relationships between tables synchronized.