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

Functional dependency, Functional Dependency Consider a relation R that... Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every

Define the term database, QUESTION (a)(i) Define the term database. ... QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c

Define a table in sql known as client for store information, Define a table... Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t

Explain the management of data store, Explain the Management of Data Store ... Explain the Management of Data Store Every system irrespective of its nature of application requires storing permanent data for consequent use in problem solving. Some objects

Data fragmentation in distributed database system, brief history,definition... brief history,definition,current trends and future trends if any of data fragmentation

Write short notes on extension and intension, Write short notes on extensio... Write short notes on extension and intension? In any data model, it is significant to distinguish among the description of the database and the database itself the description

In e-r diagram how derived attribute are represented, In E-R Diagram how de... In E-R Diagram how derived attribute are represented ? In E-R Diagram By Dashed ellipse derived attribute are represented.

Give an example of enforcement in typing, Give an example of enforcement in... Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl

Datawarehouse, Define a job scheduling strategy that will meet business req... Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Find a 3nf decomposition , Find a 3NF decomposition of the following relati... Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following