Data Redundancy and Data Consistency

How will you check data redundancy and data consistency using SQL queries?

Questions by parth1516

Showing Answers 1 - 2 of 2 Answers

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions