Update anomaly-data redundancy, Database Management System

Update Anomaly: This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014 would need that all tuples having MCS-014 enrolment information be updated. If for some reason, all tuples are not updated, we may have a database that gives 2 names of instructor for the subject MCS-014 which is inconsistent information. This problem is known as update anomaly. An update anomaly results in data inconsistency.


Posted Date: 3/7/2013 1:42:24 AM | Location : United States

Related Discussions:- Update anomaly-data redundancy, Assignment Help, Ask Question on Update anomaly-data redundancy, Get Answer, Expert's Help, Update anomaly-data redundancy Discussions

Write discussion on Update anomaly-data redundancy
Your posts are moderated
Related Questions
#question.explain diversity and magnitude of organic compounds and general properties?

Briefly describe concurrency execution? Lock - based protocols Locks There are several modes in which a data item may be locked in this section we restrict our attention

Isolation or Independence : The isolation property shows that the updates of a transaction should not be visible till they are committed. Isolation assurance that the progresses of

what is the need of a log in dbms

as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen

A step-wise distributed database design methodology Following is a step-wise methodology for distributed database design. (1) Examine the nature of distribution. Find out wh

Adding Redundant Associations for Efficient Access The expression redundant association means using "duplicate association for proficient access". While analysis, it is not a


What are the two methods for dealing deadlock problem? The two procedures for dealing deadlock problem is deadlock detection and deadlock recovery.