restion 11. Consider the following relations for a database that keeps track of flight information for an airline: pilot(pilotID, fname, lname, mint, rating, streetAddress, city, state, zip) flight(flightNumber, date, time, pilotID, departureLocation, arrivalLocation, aircraftID) aircraft(aircraftID, manufacturer, model, passengerCapacity, fuelClapacity) One of the relationships is between pilot and flight; the other is between flight and aircraft. Specify the attributes that would be foreign keys in these relations. - Do not assume any attributes are foreign keys to relations that are not listed above. - Show your answer as relation(attributeName) for as many foreign keys as are necessary