Question

How to avoid data redundacy

Answer 1

• 1st normal form: Avoid storing similar data in multiple table fields.
• Eliminate repeating groups in individual tables.
• Create a separate table for each set of related data.
• Identify each set of related data with a primary key .
• A DBMS can reduce data redundancy and inconsistency by minimizing isolated files in which the same data are repeated. The DBMS may not enable the organisation to eliminate data redundancy entirely, but it can help control redundancy.