1.Identify functional dependencies and derivecandidate keys, and 2.Follow the normalization process to determinetables and relationships based on eight tables(AIRPORT, FLIGHT, DEPARTURES, PASSENGER, RESERVATION, EQUIP_TYPE,PILOTS, and TICKET) that contain data about the Belle Airlines.Download and use data in Project 3 zip file for this project. SomeBackground on Belle Airlines Belle Airlines is a regional carrierthat operates primarily in the southwestern United States. At thepresent time, Belle Airlines operates its own reservationinformation system. To simplify our analysis, we will assume thatall reservations on Belle Airlines flights are placed through BelleAirlines employees. Flights are not booked through travel agentsand Belle Airlines does not
1identify Functional Dependencies Derive Candidate Keys 2follow Normalization Process Dete Q37062255
OR
OR