database

Part E: NORMALIZATION (15 points) 500 DOL RouteNo Destination Distance Departure Time TicketNo Date Driver No DriveName ClientNo ClientName TGOL Terengganu 9:00 27/11/2020 TK01 Ahmad C01 Kuala Maryam KLO2 600 20.00 28/11/2020 Lumpur TKO2 CO2 Razi UHOI Johor 350 8.00 29/11/2020 TK03 DO2 Izeki CO3 Aishah KL03 Kuala Lumpur 3301 21:00 TK04 30/11/2020 C04 Ibrahim 10:00 TKOS 4/12 2020 D03 Amir COS Fatimah PHOT Pahang 250 11:00 TKO6 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: 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)