Question: what is data redundancy how can this problem be removed?
Answer: Data redundancy occurs in database systems which have a field that is repeated in two or more tables. ... Database normalization prevents redundancy and makes the best possible usage of storage. The proper use of foreign keys can minimize data redundancy and reduce the chance of destructive anomalies appearing.