Question

What are the problems caused by redundancy in dbms?

Answer 1

In computer main memory, auxiliary storage and computer buses, data redundancy is the existence of data that is additional to the actual data and permits correction of errors in stored or transmitted data.

problem caused by redundancy in dbms

Storing the same field values more than once (unnecessarily) is referred to as data redundancy. Three problems are caused by data redundancy. The first is that storing values multiple times wastes space. Under a proper design (Figure 1), Kristin's information is stored only once, in her record in the Customers table.

Answer 2

Problems caused by redundancy in dbms are given below.

Explanation:

• The main problem is arising when the redundancy in dbms is arising we can not find the unique record in the database management system that's why we can used the concept of primary key that is used for finding the unique record in the database management system .
• In the Insertion or updation or deletion query we face many problem of anamoly because more then one same copy of one data is occur in the database.

Learn More :

• brainly.in/question/13301373