Question

data redundancy gives rise to data inconsistency explain this statement with the help of an example

Answer 1

"Anything that affects the data integrity results in data inconsistency, especially if you’re using the database as a System of Record.

For example, if a customer record in the database has 2 home telephone numbers, consumers of the data will be unable to determine which phone numbers to use.

One way of preventing data inconsistency would be to have adequate constraints within the database so that these situations don’t arise.

In the above example, if there was a constraint that a customer can only have one (home) phone, then while adding the 2nd one, the application (or user) would get an error and would not be added. Additionally, the data integrity would be preserved.

"

Answer 2

Explanation:

Data redundancy is a situation in where there is storage of same data at different locations. Although they are working together, they are receiving it from different outputs.

This is nothing but data inconsistency. So therefore data redundancy leads to data inconsistency