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

Ask an Expert

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

Write your message here..

Related Questions

Introduction to Database Design and Development, Every School has many teac... Every School has many teachers and many students. Each student is assigned to one school and each teacher works for one school only. Each teacher teaches more than one subject but

State the meaning of object representation, State the meaning of Object Rep... State the meaning of Object Representation  The term object representation means "to represent object with the help of objects model symbols". Implementing objects is too simp

Create records in a table - data structures, In this exercise you will crea... In this exercise you will create ten records, each containing the following fields: student name, class:  Freshman, Sophomore, Junior or Senior, Major:  Liberal Arts or General Sci

Database errors, Database Errors: An error is said to have occurred if the ... Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or

Mapping Constraints, what is Mapping Constraints? with examples what is Mapping Constraints? with examples

Decomposition.., explain concept of decomposition? explain concept of decomposition?

Query, Use a Set operator to create a list of academics who have written or... Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.

Organize the clients from email marketing, Function requirement as given: ... Function requirement as given: 1> manage fans and likes and followings those information from facebook. twitter. google+ and linkedin etc 2> Organize the clients from email m

Define a property that is not a property of transactions, Define a property... Define a property that is not a property of transactions? Ans: Concurrency is not a property of transactions

A b-tree of order how much children m has maximum, A B-tree of order how mu... A B-tree of order how much children m has maximum ? m has maximum m mchildren in a B tree.