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
Problem: (a) Briefly explain the ‘Hierarchical Database Model' using appropriate diagram. (b) List and briefly describe five potential benefits of the database approach comp

The following relational database schema represents part of a simplified database used by a library: tblBook (BookID, Title, PublisherID, Category,Price) tblPublisher (Publishe

Explain Hashing techniques The hashing techniques can be categorized as: Static Hashing Techniques - In this method, the data can be viewed a collection of buckets, along with

A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame

What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a

A file of employee have 10,000 blocks on a cylinder of a disk with characteristics r=8ms and btt=0.6ms I want to know the cost of read inthe file under following conditions for a q

write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.

How to create a biological database based on viruses. How to decide which attribute should be there in the table and schema? How to identify the primary keys, foreign keys, domain,

Express the following queries in SQL: (a) Write the SQL code that will create ALL the four tables given in the appendix. Your answer should not contain the primary key and

What is a primary key? Primary key is chosen by the database designer as the principal means of identifying an entity in the entity set.