Update anomaly-data redundancy, Database Management System

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







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
Related Questions
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

create an er diagram for production management in film industry

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

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.

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

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 customers and their account. Customer has a name, address which consists of house number, area and city, and one or more phone numbers. Ac

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

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

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