database

Part E: NORMALIZATION (15 points) Departure RouteNo Destination Distance Ticket No Date Time Driver No DriveName ClientNo ClientName TGOI Terengganu 500 9.00 27/11/2020 TK01 DOI Ahmad CO1 Kuala Maryam KLO2 600 20.00 28/11/2020 Lumpur IKOZ CO2 Razi JHOI Johor 350 8:00 29/11/2020 TK03 Zeki C03 Aishah DO2 Kuala KL03 330 21:00 TK04 30/11/2020 C04 Ibrahim Lumpur 10:00 TKOS 4/12/2020 D03 Amir COS Fatimah PHOI Pahang 250 11:00 TK06 4/12/2020 D04 Zainab 006 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)