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

Your posts are moderated

Write your message here..

Related Questions

Define seek time, Define seek time. The time for repositioning the arm ... Define seek time. The time for repositioning the arm is known as the seek time and it enhances with the distance that the arm is known as the seek time.

Explain data dictionary in short, Explain Data Dictionary in short? Explain Data Dictionary in short?

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

Write the queries in relational algebra, Problem: You are given the fol... Problem: You are given the following schema 1. Flights(flno, from, to, distance) 2. Aircraft(aid, flno, aname, cruisingRange) 3. Certified(eid, aid) 4. Employees(eid, ena

What functions does a data dictionary perform, What functions does a data d... What functions does a data dictionary perform? In a (DBMS)data management system, the principal functions performed by the data dictionary are Management of data defini

List the data structures implemented by the storage manager, List the data ... List the data structures implemented by the storage manager. The storage manager executes the following data structure a) Data files b) Data dictionary c) indices

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.

What are aggregate functions, What are aggregate functions? And list the ag... What are aggregate functions? And list the aggregate functions supported by SQL? Aggregate functions are functions that take a collection of values as input and return a one va

Complexity- drawbacks of data distribution, Complexity : A distributed DBMS... Complexity : A distributed DBMS that is available, reliable, and secure is inherently more difficult than a centralised DBMS. Though, adequate data replication is essential to have

Foreign keys , Foreign Keys and NULL Let us take the relation:         ... Foreign Keys and NULL Let us take the relation:                 DEPT DEPT ID DNAME BUDGET D1 M