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: -Answer: Data redundancy occurs when different divisions, functional areas, and groups in an organization independently collect the same piece of information.

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: -Concurrency can simply be said to be executing multiple transactions at a time. It is required to increase time efficiency. If many transactions try to access the same data, then inconsistency arises. Concurrency control required to maintain consistency data.

Detailed explanation-5: -Duplication of data is called data redundancy. Duplication of data should be checked always as data redundancy takes up the free space available in the computer memory. Data redundancy occurs when the same piece of data is stored in two or more separate places and is a common occurrence.