Normalization is a design approach that minimizes data redundancy and optimizes data structures by systematically and properly placing data elements into the appropriate groupings. i. E Explain TWO (2) types of database anomalies that may occur on a relation that has redundant data. Illustrate the process of normalizing the data shown in FIGURE Q2 from First Normal Form (1NF) to Second Normal Form (2NF), and from Second Normal Form (2NF) to Third Normal Form (3NF). E_ID L_Name F Name D_ID D_Name D_NO D SSN D_DOB [NOTE: E_ID=Employee_ID, Lname=Last_name, F_Name=First Name, D_ID=Department_ID, D_Name=Department_Name, D_NO=Dependent_NO, D_SSN=Depenedent_SSN, D_DOB-Dependent_DateOfBirth]