‘What is data integrity, and what is the significance of a lack of data integrity’?
Data integrity essentially involves the accuracy of the data in a database. When data integrity exists, it means that data values are correct, consistent, complete, and current. The way data files are organized significantly affects the consistency of information. For example, if redundant data is spread across multiple files, it can be difficult to preserve data integrity since we would have to make sure that updates are applied across multiple data files. However, if data is organized in a relational database and redundancy is eliminated through data normalization, data integrity is preserved and data consistency problems will be avoided. A poorly designed database can often ultimately be accompanied by a lack of data integrity.