database

Part E: NORMALIZATION (15 points) Departure RouteNo Destination Distance Time Ticket No Date DriverNo DriveName Client No ClientName TGOI Terengganu 500 9.00 27/11/2020 TKOI D01 Ahmad COI Kuala Maryam KL.02 6001 20.00 28/11/2020 Lumpur TKO2 CO2 Razi JHO1 Johor 350 8.00 29/11/2020 TKO3 DO2 Zeki C03 Aishah Kuala KL03 3301 21:00 TK04 30/11/2020 C04 Ibrahim Lumpur 10:00 TKOS 4/12/2020 D03 Amir COS Fatimah Pahang 250 11:00 TKO 4/12 2020 D04 Zainab C06 Yusuf PH01 The bus ticketing report shown above displays snippet of the daily transactions. Based on this report answer the following questions: 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)