![]() This process works through different stages known as normal forms. It is used to create a suitable set of relations for storing data. The process of producing a simpler and more reliable database structure is called normalization. In thisĪnomaly, the modification in the value of a specific attribute requires modification in all The modification anomaly occurs when the record is updated in the relation. In thisĪnomaly, the deletion of facts about an entity automatically deletes the fact of another entity. The deletion anomaly occurs when a record is deleted from the relation. In thisĪnomaly, the user cannot insert a fact about an entity until he has an additional fact about The insertion anomaly occurs when a new record is inserted in the relation. It is important to remove these anomalies in order to perform different processing on the relations without any problem.ĭifferent types of database anomalies are as follows: Some important data may be lost if a relation is updated that contains database anomalies. These anomalies affect the process of inserting, deleting, and modifying data in the relations. Database anomalies are the problems in relations that occur due to redundancy in the relations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |