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

Draw an e-r diagram and convert it to a relational schema, In an organizati... In an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the

Tuples-attributes , Consider a relation s over the attributes A and B wit... Consider a relation s over the attributes A and B with the following characteristics: 5,000 tuples with 10 tuples per page A 2-level B+ tree index on attribute

What is the disadvantage of a call by reference, What is the disadvantage o... What is the disadvantage of a call by reference? During a call by reference damage or loss of data is not restricted to the subroutine, but will instantly lead to alters to th

Extend the database, Now that she understands more about the benefits of da... Now that she understands more about the benefits of databases, the play-scheme manager would like to extend the play-scheme database to include data for schools and instructors as

Normalization database, I need some help with my normalization database hom... I need some help with my normalization database homework.

Example of database optimisation, Create 1 experiment to demonstrate an asp... Create 1 experiment to demonstrate an aspect of query optimisation by using access-path structures (indexes), decomposition, or denormalisation. Once satisfied with your experiment

What is functional dependency, What is Functional Dependency? A Functi... What is Functional Dependency? A Functional dependency is shown by X Y among two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple

Prepare a site map and submit it in bing and google, Project Description: ... Project Description: I am updating my Javascript + HTML website with five domains for the same website I would like to know if I want to create site map and submit it in all the

Explain candidate key, Explain Candidate key? Candidate Key - A candi... Explain Candidate key? Candidate Key - A candidate key is a minimal superkey, that can be used to uniquely identify a tuple in the relation.

Need for distributed database systems, Need For Distributed Database System... Need For Distributed Database Systems A distributed database is a set of database kept on multiple computers that appears to applications as a one database. As a result, an app