Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



What is Database Anomaly

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-05-2009
Member
 
Join Date: Feb 2009
Posts: 58
What is Database Anomaly
  

hi friends,

What do you mean by the term called " Database Anomaly " in the database management systems? Can anyone provide me the information and explanation about the same ?

thanks a lot.....

Reply With Quote
  #2  
Old 06-05-2009
Member
 
Join Date: May 2008
Posts: 2,379
Re: What is Database anomaly

Database Anomalies
Database anomalies are the problems in relations that occur due to redundancy in the relations. These anomalies affect the process of inserting, deleting and modifying data in the relations. Some important data may be lost if a relation is updated that contains database anomalies. It is important to remove these anomalies in order to perform different processing on the relations without any problem.

Types of Anomalies - Different types of database anomalies are as follows:
  • Insertion Anomaly - The insertion anomaly occurs when a new record is inserted in the relation. In this anomaly, the user cannot insert a fact about an entity until he has an additional fact about another entity.

  • Deletion Anomaly - The deletion anomaly occurs when a record is deleted from the relation. In this anomaly, the deletion of facts about an entity automatically deleted the fact of another entity.

  • Modification Anomaly - The modification anomaly occurs when the record is updated in the relation. In this anomaly, the modification in the value of specific attribute requires modification in all records in which that value occurs.
Reply With Quote
  #3  
Old 06-05-2009
Member
 
Join Date: May 2008
Posts: 2,004
Re: What is Database Anomaly

Database Anomaly is the constraint in database management systems that prevents you from adding/update/delete the specific information/fact until you add/update/delete another information/fact that is required before.

In database anomaly, there is -

- insertion anomaly
- update anomaly
- delete anomaly

Insertion anomaly indicates that we cannot add a data into the relations until another data is added....
Reply With Quote
  #4  
Old 06-05-2009
cason
 
Posts: n/a
Re: What is Database Anomaly

As I know database anomalies are the problems in relations that occur due to redundancy in the relations. These anomalies affect the process of inserting, deleting and modifying data in the relations.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What is Database Anomaly"
Thread Thread Starter Forum Replies Last Post
Is Linux version of Anomaly Warzone Earth releasing? Sosie Video Games 4 12-04-2011 08:07 PM
Anomaly Warzone Earth stream launch disappeared Jagad Video Games 5 12-04-2011 08:03 PM
Is there any way to play Anomaly Warzone Earth via keyboard? The^Affleck Video Games 5 12-04-2011 08:02 PM
I see all the vehicles on the map as white while playing Anomaly Warzone Earth Sera-phina Video Games 5 12-04-2011 08:01 PM


All times are GMT +5.5. The time now is 05:32 PM.