Data integrity, altered or destroyed, unauthorized manner, corrupted data, accidental changes, referential integrity
Data Mill Backup tutorial
Data integrity refers to a condition of the data in which data has not been altered or destroyed in an unauthorized manner.
Data Integrity describes the reliability of the data. If the data has integrity it means that it has not been corrupted or accidentally changed. If the data has integrity and reliability then it is also up to date and we know that the data can be relied upon for statistical use or reporting. In a relational database it is important that the data also has referential integrity. If it doesn’t then the data cannot be relied upon at all and any query may not really be accurate. If there is no referential integrity then data may be duplicated and an employees dependants may be listed for an employee that has not been entered into the database.