Database data redundancy (MS Access)

[JimAroo]

Hello,

Would I be correct in thinking that data redundancy is something that forces matching data across a relational database? For example if I want to change my CustID to CustomerID this would change the CustID field to CustomerID across the entire database relationships fields?

Thanks.

 

[lokkers]

Hello,

Would I be correct in thinking that data redundancy is something that forces matching data across a relational database? For example if I want to change my CustID to CustomerID this would change the CustID field to CustomerID across the entire database relationships fields?

Thanks.

No, it seems that it's a lack of normalisation within a database.

http://www.databasedev.co.uk/data-redundancy.html

 

[Eddie]

I think you might be getting a couple of things confused there. Data redundancy is just having stuff (usually just columns, but can be entire tables) in your database you never use, or storing the same data multiple times in different tables, as in the data becomes redundant, not needed.

Normalisation, if applied correctly, will remove any redundancy.

 

[JimAroo]

Ah now I understand.

Thanks guys.