List all the join conditions or join paths pairwise existing

List all the join conditions or join paths (pairwise) existing between these tables

EMPLOYEE RNAME MINTINANE SSN | BOATE ADDRESSE SALARY SUPERSSN ONO DEPARTMENT DANIE DNUMBERGROSS MGRSTARTDATE DEPT LOCATIONS DNUMBER DLOCATION PROJECT nue POCATION NUM WORKS_ON ESSN PNO HOURS DEPENDENT ESSNDEPENDENT NAME SEXBDATE RELATIONSHIP

Solution

EMPLOYEE.DNO = DEPARTMENT.DNUMBER DEPARTMENT.DNUMBER = DEPT_LOCATIONS.DNUMBER DEPARTMENT.DNUMBER = PROJECT.DNUM PROJECT.PNUMBER = WORKS_ON.PNO EMPLOYEE.SSN = WORKS_ON.ESSN EMPLOYEE.SSN = DEPENDENT.ESSN EMPLOYEE.SSN = DEPARTMENT.MGRSSN