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
I have a homework assignment due today by midnight. I need help understanding databasse normalization and determining the type of form violation & how to fix the violation.

Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)

What is data block? Data Block - In oracle the data blocks are referred to as tablespaces. A tablespace is an fields of disk consisting of one or more disk files. A tablespace

need to get answer for questions 3&4 on this page in part 1

The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.

Text Processing: Use readLines to read SOU.txt into R. Create a vector called Pres containing the names of the presidents giving each speech. To do this, rst identify the lin

(a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

I have been given 8 differebt data warehouseing failure case studies. I need to question 4 questions for each

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

Find out the names and company names of all employees sorted in ascending order of company name and descending order of employee names of by which company. SELECT EMPLOYEE_NAME,