Question: Problem 3: Normalization (20 pts Open with Google Docs Consider the following table and functional dependencies: FLIGHTNO PASSENGER NAME PASSENGER PHONE James 76767676 COMPANY DEPARTURE

Problem 3: Normalization (20 pts Open with Google Docs Consider the following table and functional dependencies: FLIGHTNO PASSENGER NAME PASSENGER PHONE James 76767676 COMPANY DEPARTURE CITY MEA Beirut 1001 Mary 05050505 1003 Lufthansa Frankfurt Robert 06060606 1001 MEA Beirut ARRIVAL COMPANY CITY PHONE Paris 9611111111; 9611222222 London 0491231231; 0493334445 Paris 9611111111; 9611222222 Beirut 9611111111; 9611222222 London 0491231231; 0493334445 Rome 0339998888 John 81818181 1005 MEA Istanbul James 12312312 1003 Lufthansa Frankfurt Smith 25252525 1015 Air France Paris 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
