employee {e_id_pk, e_name}
loc_emp {loc_e_id_pk, e_id_fk, t_id_fk}
location {loc_id_pk, loc_direction}
trip {tr_id_pk, e_id_fk, tran_id_fk, tr_desc}
transport {tran_id_pk, tran_desc}

SELECT
  employee_id, fullname, passport, phone, position, direction, title,
  trip_code
FROM
  t_facility
  INNER JOIN t_employee_facility USING (facility_id)
  INNER JOIN t_employee USING (employee_id)
  INNER JOIN t_trip USING (employee_id)
GROUP BY
  employee_id,
  facility_id,
  trip_code