The Employee_histories table is joined to the Employees table on "ssn" and to the Positions table on "position_code." The application ensures referential integrity; the user is not allowed to specify a Social Security number or position code in a record in the Employee_histories table if there is no corresponding record in the Employees table or Positions table.