sandesh mastake

• Apr 23rd, 2013

 

Data redundancy means youre checking for duplication. In order to make that check, you need to determine what signifies a duplicate within the table to which you are referring. There is not a single query that will satisfy until you can define what makes a duplicate record.

Data consistency is completely a business model. There is no way from a pure programming stand point to know that, for example, NY and New York are either incorrect or correct values for a given field unless someone has defined that the data must look a certain way.

Khemchand Mahajan

• Aug 26th, 2017

 

By using Normalisation Concept we can check data redundancy and consistency problem.