FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Data redundancy occurs when the same piece of data exists in multiple places, whereas data inconsistency is when the same data exists in different formats in multiple tables.

Detailed explanation-2: -Data inconsistency-Data inconsistency exists when different and conflicting versions of the same data appear in different places.

Detailed explanation-3: -What is Data Inconsistency? Data inconsistency is a situation where there are multiple tables within a database that deal with the same data but may receive it from different inputs. Inconsistency is generally compounded by data redundancy.

Detailed explanation-4: -For instance, assume a hospital database. Changing the address of one patient can affect many other tables. Only one record will have correct data while the others will have false data. Hence, this is data inconsistency.

Detailed explanation-5: -Data inconsistency problems can occur as a result of referential integrity constraint violations. Referential integrity describes the condition where all references to data in pages are valid. Db2 provides referential integrity by enforcing referential constraints on the data.