Data Redundancy

• A major aim of database design is to group attributes into relations so as to minimize data redundancy.
• Problems associated with data redundancy are illustrated by comparing the Staff and Branch relations with the Staff_Branch relation in the following example.
• Relation that have redundant data may suffer from update anomalies.
• The occurrence of value for data element more than once within a database or a file.