Need proper answer only

please need the answer

Part E: NORMALIZATION (15 points) Departure RouteNo Destination Distance TicketNo Date Time Driver No DriveName ClientNo ClientName TG01 Terengganu 500 27/11/2020 9:00 TK01 20:00 D01 Ahmad C01 Maryam KL02 Kuala Lumpur 6001 28/11/2020 CO2 Razi JHO1 Johor 350 TK02 8:00 TK03 29/11/2020 DO2 Zeki CO3 Aishah KLO3 Kuala Lumpur 3301 21:00 TK04 30/11/2020 C04 Ibrahim 10:00 IKOS 4/12/2020 D03 Amir COS Fatimah PHOI Pahang 250 11:00|TK06 4/12/2020 D04 Zainab C06 Yusuf The bus ticketing report shown above displays snippet of the daily transactions. Based on this report answer the following questions: 1. Identify the functional dependencies (primary, partial, and transitive if any) in the relation above based on the information given to you. Specify whether it is primary, partial, or transitive. (4 points) 2. Perform normalization process to this relation based on the following steps; 1st Normal Form, 2nd Normal Form and finally the 3rd Normal Form. Your answers are the final relations or tables created after you have performed all three Normal Form. Please indicate the primary keys or/and foreign key(s) for all the relations. (6 points) 3. Using your findings in Question 2 of Part E, draw an ERD to reflect the properly decomposed normalized tables. Show all the relationships, attributes, primary key, foreign key, and multiplicities. (5 points) Part E: NORMALIZATION (15 points) Departure RouteNo Destination Distance TicketNo Date Time Driver No DriveName ClientNo ClientName TG01 Terengganu 500 27/11/2020 9:00 TK01 20:00 D01 Ahmad C01 Maryam KL02 Kuala Lumpur 6001 28/11/2020 CO2 Razi JHO1 Johor 350 TK02 8:00 TK03 29/11/2020 DO2 Zeki CO3 Aishah KLO3 Kuala Lumpur 3301 21:00 TK04 30/11/2020 C04 Ibrahim 10:00 IKOS 4/12/2020 D03 Amir COS Fatimah PHOI Pahang 250 11:00|TK06 4/12/2020 D04 Zainab C06 Yusuf The bus ticketing report shown above displays snippet of the daily transactions. Based on this report answer the following questions: 1. Identify the functional dependencies (primary, partial, and transitive if any) in the relation above based on the information given to you. Specify whether it is primary, partial, or transitive. (4 points) 2. Perform normalization process to this relation based on the following steps; 1st Normal Form, 2nd Normal Form and finally the 3rd Normal Form. Your answers are the final relations or tables created after you have performed all three Normal Form. Please indicate the primary keys or/and foreign key(s) for all the relations. (6 points) 3. Using your findings in Question 2 of Part E, draw an ERD to reflect the properly decomposed normalized tables. Show all the relationships, attributes, primary key, foreign key, and multiplicities. (5 points)