What is data redundancy ? How does it impact a database ?

Duplication of data is known as data redundancy. Data redundancy in a database leads to wasted storage and multiple copies of the same data. When these copies do not match with one another, it leads to data inconsistency. Additionally, data redundancy can result in performance degradation, security risks, and increased complexity.