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

Your posts are moderated

Write your message here..

Related Questions

What is datawarehousing, What is DataWarehousing? Subject-oriented, me... What is DataWarehousing? Subject-oriented, meaning that the data in the database is organized so that all the data elements relating to the similar real-world event or object

Differentiate between static hashing and dynamic hashing, Differentiate bet... Differentiate between static hashing and dynamic hashing.  Ans: Static Hashing comprises the number of primary pages in the directory fixed. So, while a bucket is full, we requ

In oracle what is system global area and how is it organized, In Oracle wha... In Oracle what is system global area and how is it organized? The SGA is a collection of shared memory fields which along with the Oracle processes constitute an Oracle instan

What is predictive modelling, Problem: (a) Data mining is one of the b... Problem: (a) Data mining is one of the best ways to analyse data and using software techniques, hidden and unexpected patterns and relationships in sets of data can be extrac

Describe different steps of object-oriented design process, Describe differ... Describe different steps of the object-oriented design process.  The broad steps of the object-oriented design process are: a. Define context and modes of use of the system

What is the main goal of raid technology, What is the main goal of RAID tec... What is the main goal of RAID technology? Describe the levels 1 through 5. RAID stands for Redundant Array of Inexpensive (or sometimes "Independent")Disks. RAID is a met

Define radix conversion method, Define Radix conversion method  One cle... Define Radix conversion method  One clever way to transform binary numbers to BCD notation (binary-coded decimal) is the "double dabble algorithm". It can be adapted to transfo

Explain generalization and aggregation in e_r diagram, Explain the concept ... Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug

Differance between procedural and non procedural dml, Differance between pr... Differance between procedural and non procedural DML? Procedural and non procedural DML Procedural DML exactly what data is require and how to obtain those data. Non procedural

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