The employees table has a Primary key "Employee_ID" and 3 Foreign keys "JOB_ID", "Manager_ID" and "Department_ID".
The "Manager_ID" foreign key is a key to the same Employee table I.E "Employee_ID"
2.2 (A ran this in the Oracle DB interface)
SELECT
EMPLOYEE_ID emp#,
LAST_NAME Employee,
JOB_ID Job,
HIRE_DATE Hire
FROM EMPLOYEES