Calibri (Body) 12 Aa 5 e 21 T BIU nat Painter abc X X v aby A H Font Paragraph USLI rinal exam rail ZUZI - ZULL Problem 3: Normalization (20 pts) Consider the following table and functional dependencies: PASSENGER NAME PASSENGER PHONE FLIGHTNO COMPANY DEPARTURE CITY ARRIVAL CITY COMPANY PHONE James 76767676 1001 MEA Beirut Paris 9611111111: 9611222222 Mary 05050505 1003 Lufthansa Frankfurt London Robert 06060606 1001 MEA Beirut Paris 0491231231: 0493334445 9611111111 9611222222 9611111111: 9611222222 John 81818181 1005 MEA Istanbul Beirut James 12312312 1003 Lufthansa Frankfurt London 0491231231 0493334445 Smith 25252525 1015 Air France Paris Rome 0339998888 I PASSNEGR_NAME -> PASSENGER_PHONE FLIGHT_NUM -> COMPANY, DEPARTURE_CITY, ARRIVA_CITY COMPANY -> COMPANY_PHONE 1) The table is susceptible to anomalies. Provide examples of insertion, deletion, and update anomalies 2) Describe and illustrate the process of normalizing the table into 3NF SE 884 words English (United States) Accessibility: Investigate