FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Redundancy exists when the same data are stored unnecessarily at different places. Data anomaly develops when all of the required changes in the redundant data are not made successfully.

Detailed explanation-2: -Problems caused due to redundancy are: Insertion anomaly, Deletion anomaly, and Updation anomaly.

Detailed explanation-3: -Database normalization is the process of efficiently organizing data in a database so that redundant data is eliminated.

Detailed explanation-4: -Redundancy is the duplication of data or the storing of the same data in more than one place. Redundancy wastes space b/c you’re storing the same data in multiple places. The extra space results in larger spreadsheets that require more space in memory and on disk that take longer to save and open.

Detailed explanation-5: -Data redundancy refers to the practice of keeping data in two or more places within a database or data storage system. Data redundancy ensures an organization can provide continued operations or services in the event something happens to its data–for example, in the case of data corruption or data loss.