Question
What are the problems associated with data Redundancy in a relation? How can you solve those problems? Can referential integrity constraints help in addressing those problem? Give reasons in support of your answer.
Answer :
Word Count : 137
________ ______ __________ _______ __________ _______ _______.
______ _________ ______ ______ __________ _________ __________ __________ _______ ___.
_________ ____ ______ _______ _________ ___.
________ _________ ________ _______ ___ ___.
___ ____ _______ ___ ____ _________ ___ ________.
_________ ________ _____ _______ ___ _______ __________ ________ __________ ______ ____.
______ __________ _______ ____ __________ __________ ___ _________ ____.
_____ _______ _____ _____ ________ ________ ______ _________ _________.
_______ _____ ____ ______ _________.
_______ _______ _________ ____ ___ __________ _______ _________ _________ __________ _______ ________.
_______ _____ ______ _____ _____ _________.
Skip in 10
DATA REDUNDANCY : In file processing system the same copy of data are stored more than once is called data redundancy. I large organization the same information may be duplicate in several place. For example the address and telephone no. of particular customer may appear in file that
______ _________ ______ ______ __________ _________ __________ __________ _______ ___.
_________ ____ ______ _______ _________ ___.
________ _________ ________ _______ ___ ___.
___ ____ _______ ___ ____ _________ ___ ________.
_________ ________ _____ _______ ___ _______ __________ ________ __________ ______ ____.
______ __________ _______ ____ __________ __________ ___ _________ ____.
_____ _______ _____ _____ ________ ________ ______ _________ _________.
_______ _____ ____ ______ _________.
_______ _______ _________ ____ ___ __________ _______ _________ _________ __________ _______ ________.
_______ _____ ______ _____ _____ _________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.