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

What is meant by software and hardware raid systems, What is meant by softw... What is meant by software and hardware RAID systems? RAID can be executed with no change at the hardware level, using only software modification. Such RAID implementations are

Production management, create an er diagram for production management in fi... create an er diagram for production management in film industry

What is primary key, What is Primary key? Primary Key - Primary key i... What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.

System Analysis and design, Using the questions found at the end of Chapter... Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.

Relational algebra and calculus, Q.  What is relational algebra and calcul... Q.  What is relational algebra and calculus? Explain the relational algebra operators :- Selection and predicate, set operation, joins and division. Sol. Relational Algebra

Information system fundamentals, A full discription of the new, a discripti... A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

1) Information about a bank is about customer, 1) Information a... 1) Information about a bank is about customers and their account. Customer has a name, address which consists of house number, area and city, and one or more phone numbers. Ac

By the relations get details of employees working in sql, Consider the rela... Consider the relations: PROJECT(proj#,proj_name,chief_architect) EMPLOYEE(emp#,emp_name) ASSIGNED(proj#,emp#) Use relational algebra to express the subsequent queries: (i) Get

Function module, When a function module is activated syntax checking is per... When a function module is activated syntax checking is performed automatically. YEs, a function module is activated syntax checking.

Datawarehouse, 1) Define a job scheduling strategy that will meet business ... 1) 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 pict