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. Unfortunately, data redundancy can cause data inconsistency, which can provide a company with unreliable and/or meaningless information.

Detailed explanation-2: -The redundant data results in more accuracy, reliability and security whereas elimination helps in energy saving as most of the energy of sink node gets waste in dealing with the redundant data. Data accuracy still needs to be preserved even if there is increase in network cost and/or time.

Detailed explanation-3: -Data inconsistency refers to a situation of keeping the same data in different formats in two different tables or a situation where it requires to match the data between tables. However, this can cause one table in the database to have the correct value and the remaining tables to be different.

Detailed explanation-4: -Redundancy causes insertion, deletion, and updation anomalies. Redundancy can be avoided by normalizing the database, maintaining master data, etc.