Need it in 1 hour.

Q 2: 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 _name D_id D_HOD C_id |C_Name |T_id |T_Name T_Address Desiguation Grade S1 AB Khan Lahore CS IS2 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 Ansari C1 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 S3 Ayaz Mazhar Lahore SE S4 Saima Rana Islamabad CE C7 Data Structures T8 Ms. Tuba Lahore Lecturer A- C8 JOOAD 19 Ms. Maryiam Lahore Lecturer B+ |D2 Dr. Ejaz Ansari C1 Database Systems T1 Dr. Sana Lahore Assistant Professor B- C5 Software Engineering |T2 Dr. Ali 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 JOOAD T9 Ms. Maryiam Lahore Lecturer B- S5 Anees S6 Maria Mirza Faisalabad CS Nazeer Sialkot SE