PART I: Overview of Normalization

DBMS Anomalies There are three types of anomalies that occur when the database is not standardized. These are anomalies when inserting, updating as well as deleting. Let’s take an example to understand this. Example: Suppose a manufacturing company stores the employee details in a table called employees with four attributes: emp_id to save the employee ID, emp_name to save the…