Q2: Describe and illustrate the process of normalizing the below table to 3NF. State any assumptions you make about the data shown in this table. [15 Marks) s_ids_fname S_Iname S_address D_name D_id D_HOD C_id Name T_id T Name T_Address Designation Grade S1 AL Khan Lahore CS S2 Sara Ahmad Lahore CE D1 Dr. Zulfiqar Habib |C1 Database Systems T1 Dr. Sana Lahore Assistant Professor A C5 Software Engineering |T2 Dr. Ali Karachi Assistant Professor B- C3 Artificial Intelligence T3 Dr. Hamid Islamabad Associate Professor B- D2 Dr. Ejaz Ansarici Database Systems T1 Dr. Sana Lahore Assistant Professor B- C2 Networking T4 Dr. Asad Sialkot Associate Professor B C4 JOOP T5 Ms. Rabia Sialkot Lecturer B+ D3 Dr. Ghulam Rasool |C6 Professional Practices T7 Mr. Tayyab Peshawar Lecturer A S3 Ayaz Mazhar Lahore SE S4 Saima Rana Islamabad CE C7 Data Structures T8 Ms. Tuba Lahore Lecturer A. C8 JOOAD T9 Ms. Maryiam Lahore Lecturer B+ D2 Dr. Ejaz Ansarici Database Systems T1 Dr. Sana Lahore Assistant Professor B- C5 Software Engineering T2 Dr. Al Karachi Assistant Professor B C3 Artificial Intelligence T3 Dr. Hamid Islamabad Associate Professor A- C10 Automata T6 Ms. Mahrukh Lahore Lecturer B+ D1 Dr. Zulfiqar Habib C2 Networking T4 Dr. Asad Sialkot Associate Professor A D3 Dr. Ghulam Rasool |C8 OOAD 19 Ms. Maryiam Lahore Lecturer B- S5 Anees Mirza Faisalabad CS S6 Maria Nazeer Sialkot SE