This process was developed by E.F.Codd. Normalization is basically used to improve performance by reducing redundant information from the database. In other words normalization is used to reduce the table in normal forms. But the problem occur in normalization is anomalies.
There are various types of anomalies in database.
- Deletion Anomaly
- Insertion Anomaly
- Updation Anomaly
Consider the Student Relation. The attribute of the Student relation are SID, Fee, Activity
Suppose that each student activity has a fixed fee that is same for all students. If we delete the row for the student table sid (100), we lose a whole tuple related to that row.
Suppose we want to enter information in Student Table and we have information only sid (more…)
This content is restricted to site members. If you are an existing user, please log in. New users may register below.