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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!