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

Which is an advantage of view, Which is an advantage of view? The Advan... Which is an advantage of view? The Advantages of view is Data security, Derived columns and Hiding of complex queries

What is persistency, What is persistency? Persistency ensures which dat... What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users

Explain the term- collation, What is Collation Collation is a kind of ... What is Collation Collation is a kind of sort order. There are majorly 3 types of sort orders, namely: i.) Dictionary case insensitive ii.)Dictionary - case sensitive

What is horizontal fragmentation, What is horizontal fragmentation? Hor... What is horizontal fragmentation? Horizontal fragmentation divides the relation by assuming every tuple of r to one or more fragments

MS Access 2010 - Form Updates Table, Hi there, Have an issue with my Databa... Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect

ERD DIAGRAM, Law Associates is a large legal practice based in Sydney. You... Law Associates is a large legal practice based in Sydney. You have been asked to design a data model for the practice based upon the following specification: The practice employs

Locking, define locking in simple language and decribed it define locking in simple language and decribed it

What are called journaling file systems, What are called journaling file sy... What are called journaling file systems? File systems that support log disks are known as journaling file systems.

Components of a typical database environment, Question: (a) List four d... Question: (a) List four disadvantages of the File Processing System as compared to the Database Systems. (b) The integrity of a database is enforced by integrity rules. One

Define page, Define page. The database is partitioned into some number ... Define page. The database is partitioned into some number of fixed-length blocks, which are referred to as pages.