what is the difference between repeating groups and data redundancy

1 answer

Repeating groups refer to instances where the same set of data fields are repeated within a single table or record in a database. This can lead to inefficiency and inconsistency in data management, as changes made to one instance of the data may not be reflected in all instances.

Data redundancy, on the other hand, refers to the duplication of data within a database. This can occur when the same data is stored in multiple tables or records, leading to inconsistencies and potential data integrity issues.

In summary, repeating groups refer to the repetition of data fields within a single table or record, while data redundancy refers to the duplication of data across multiple tables or records in a database. Both can lead to inefficiencies and data integrity issues, but they are caused by slightly different factors.