Question: what is data redundancy and how can you avoid it?
Answer: Database normalization prevents redundancy and makes the best possible usage of storage. The proper use of foreign keys can reduce data redundancy and the chance of destructive anomalies appearing. The efficiency of database system can sometimes be traced back to redundant data design.