Redundancy means having multiple copies of same data in the database. This problem arises when a database is not normalized. Suppose a table of student details attributes are: student Id, student name, college name, college rank, course opted.
As it can be observed that values of attribute college name, college rank, course is being repeated which can lead to problems. Problems caused due to redundancy are: Insertion anomaly, Deletion anomaly, and Updation anomaly.
- Insertion Anomaly –
If a student detail has to be inserted whose course is not being decided yet then insertion will not be possible till the time course is decided for student.
This problem happens when the insertion of a data record is not possible without adding some additional unrelated data to the record.
- Deletion Anomaly –
If the details of students in this table is deleted then the details of college will also get deleted which should not occur by common sense.
This anomaly happens when deletion of a data record results in losing some unrelated information that was stored as part of the record that was deleted from a table.
It is not possible to delete some information without losing some other information in the table as well.
- Updation Anomaly –
Suppose if the rank of the college changes then changes will have to be all over the database which will be time-consuming and computationally costly.
If updation do not occur at all places then database will be in inconsistent state.
Reference – practice.geeksforgeeks.org
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Vertical Redundancy Check (VRC) or Parity Check
- Longitudinal Redundancy Check (LRC)/2-D Parity Check
- How to pre populate database in Android using SQLite Database
- Difference between Database Administrator (DBA) and Database Engineer
- Difference between Centralized Database and Distributed Database
- Difference between Open Source Database and Commercial Database
- Database Management Systems | Set 1
- Database Management Systems | Set 2
- Database Management Systems | Set 3
- Database Management Systems | Set 4
- Database Management Systems | Set 5
- Database Management Systems | Set 6
- Database Management Systems | Set 7
- Database Management Systems | Set 10
- Database Management Systems | Set 8
- Database Management Systems | Set 9
- Database Management Systems | Set 11
- How to store a password in database?
- Introduction of Database Normalization
- Database Management System | Dependency Preserving Decomposition
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.