Deletion Anomalies

Last updated Dec 14, 2021 Edit Source

• Cs databases

When you have a redundant database and you delete all tuples that contain a certain value for a certain attribute. All data on that attribute is lost, making it impossible to create new tuples with that attribute.

For instance, in the table:

When you delete the student yigit, all information on the class Java is lost. In order to prevent such cases, it is a good idea to apply Normalizing a Relational Model to your database.