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

Create a technology web server, Database design Database tables will be... Database design Database tables will be created for you on the Technology web server. The schema will be as follows. Please note that this is a simplified database structure, d

Data Minnning, Can i get help with weka software Can i get help with weka software

Self-join, Self-Join:   In a self join a table is joined with itself.  Let ... Self-Join:   In a self join a table is joined with itself.  Let consider the following sample partial data of EMP table EMPNO ENAME MGRID

Partial relation emp-get the details people with min salary, Let consider t... Let consider the given partial relation EMP. Let us make some sub-queries for them EMPNO ENAME JOB SAL DEPTNO 7566

Mention the several levels in security measures, Mention the several levels... Mention the several levels in security measures. A) Database system B) Operating system C) Network D) Physical Human

What is relationship, What is relationship? Give examples A relationshi... What is relationship? Give examples A relationship is an association between several entities. Example: A depositor relationship associates a customer with every account tha

Give detail description on transactions, Give detail description on Transac... Give detail description on Transactions. - Using transactions we can group all SQL commands into a single unit. - Transaction begins with some task and finishes only when a

What is hash file organization, What is hash file organization? What are t... What is hash file organization? What are the causes of bucket overflow within a hash file organization? What can be completed to decrease the occurrence of bucket overflow?

What is a database graph, What is a database graph? The partial orderin... What is a database graph? The partial ordering implies that the set D may now be viewed as a directed acyclic graph, known as a database graph.

Misuse of data or a database, As with other software, databases can potenti... As with other software, databases can potentially be used for unethical purposes. As a database developer, and a consumer, you should recognize database misuse, and how it may affe