data science problem

Question: please tell considerations you have in selecting the optimal configuration for the relations in the previous question -- in particular, the placement of foreign and/or primary keys

previous question

Name 2 Letter code emplD Name custID Name Email 1..N # of miles Airline Employs Employee Customer 1..1 License date 1..1 buys Pilot Flight Attendant 1..3 1..N commands assigned_to assigned_to ...N p..M O..N 0..1 1..M Flight books Ticket -1..N Dest Flight# Dep Dest Origin Ticket# elect the optimal the pilot and riignt relations, considering, specifically, the relationship labelled "commands" Be sure to select the best/optimal set up of these relations/tables. Pilot(EmplD, License_Date) Flight(Flight#, Departure, Destination) Pilot(EmplD, License_Date) Flight(Flight#, Departure, Destination, EmplD) Pilot(EmplD, License_Date, Flight#) Flight(Flight#, Departure, Destination) Pilot(EmplD, License_Date) Flight(Flight#, Departure, Destination) Commands(EmplD, Flight #)