Data Anomalies | Database | A/L ICT | S.N.VITHOO | ICT Foundation | Jaffna | Tamil Tutorials

Data Anomalies | Database | A/L ICT | S.N.VITHOO | ICT Foundation | Jaffna | Tamil Tutorials Anomalies are caused when there is too much redundancy in the database's information. Anomalies can often be caused when the tables that make up the database suffer from poor construction. So, what does "poor construction" mean? Poor table design will become evident if, when the designer creates the database, he doesn't identify the entities that depend on each other for existence, like the rooms of a hotel and the hotel, and then minimize the chance that one would ever exist independent of the other. The normalization process was created largely in order to reduce the negative effects of creating tables that will introduce anomalies into the database. There are three types of Data Anomalies: Update Anomalies, Insertion Anomalies, and Deletion Anomalies. Previous Video: ACID In Database Transactions I ACID | Database | Transactions | S.N.VITHOO | ICT Foundation | Jaffna | Tamil Tutorials https://youtu.be/4GP1mpmg7QA Follow us , Web : https://bit.ly/ictfoundationofficial Instagram : https://www.instagram.com/ict_foundation/ Telegram : https://t.me/joinchat/1lnmQnzMtxZiZmQ9 Facebook : https://www.facebook.com/ICT-Foundation-106879784957831 Youtube : https://www.youtube.com/channel/UCIrMAIw4JsCg3cCkqvH_R0Q