Home TechnologyProgrammingSQL & Databases Subscribe to RSS

What Are The Database Anomalies? Discuss Insertion, Deletion And Modification Anomalies?

Answer Question

1 Answer - Sort by: Date | Rating

    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 elations 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.
    0 0

    Pretty123  

    answered 3 years ago

      More

         
         

        Ask a Question via Twitter

        Send a question to @askblurtit and we will publish it online and send you a reply everytime you receive an answer.

        Blurtit Store

        Get T-shirts, hoodies, caps and more at the Blurtit store

        Blurtit International