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 C Name Tid T Name T_Address Designation Grade Si Ali Khan Lahore CS S2 Sara Ahmad Lahore CE D1 Dr. Zulfiqar Habib C1 Database Systems 11 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 JA S3 Ayaz Mazhar Lahore SE S4 Saima Rana Islamabad CE C7 Data Structures T8 Ms. Tuba Lahore Lecturer A- C8 OOAD T9 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 2009 T9_Ms. Maryiam Lahore Lecturer B- S5 Anees Mirza Faisalabad CS S6 Maria Nazeer Sialkot SE