1. List all the join conditions or join paths (pairwise) existing between these tables. 2. List the primary key and all the foreign keys in each table. 3. Based on each pair of primary key and foreign key, given in D, please give the description of referential integrity constraint involving each of primary key and foreign key. Please also indicate which one is the recursive referential integrity constraint and which one is the mutual recursive referential integrity constraint. [The description of the referential integrity constraint can be in the format as follows: Foreign key DNO in Employee table references to the Primary key DNUMBER in Department table].

SQL> select * from jps. employee; NAME SSN BDATE SEX SALARY SUPERSSN DNO John B Smith Franklin I Wong Alicia u Zelaya Jennifer S Wallace Ramesh K Narayan Joyce A English Ahmad V Jabbar James E Borg 123456789 09-JAN-55 M 333445555 08-DEC-45 M 999887777 19-JUL-85 F 987654321 20-JUN-31 F 666884444 15-SEP-52 M 453453453 31-JUL-62 F 987987987 29-MAR-59 M 888665555 10-NOV-27 M 30000 333445555 5 40000 888665555 5 25000 987654321 4 43000 888665555 4 38000 333445555 5 25000 333445555 5 25000 987654321 4 55000 1 8 rows selected. SQL> select * from jps. department; DNAME DNUMBER MGRSSN MGRSTARTD 5 Research Administration Headquarters 4 1 333445555 22-MAY-78 987654321 01-JAN-85 888665555 19-JUN-71 SQL> select * from jps.project; PNAME PNUMBER PLOCATION DNUM ProductX 1 ProductY 2 Productz 3 Computerization 10 Reorganization 20 Newbenefits 30 Bellaire Sugarland Houston Stafford Houston Stafford 5 5 5 4 1 4 6 rows selected. SQL> select * from jps.deptlocation; DNUMBER DLOCATION 1 4 5 5 5 Houston Stafford Bellaire Houston Sugarland SQL> select * from jps.workson; ESSN PNO HOURS 1234567891 123456789 2 666884444 3 453453453 1 453453453 2 333445555 2 333445555 3 333445555 10 333445555 20 999887777 30 999887777 10 32.5 7.5 40 20 20 10 10 10 10 30 10 ESSN PNO HOURS 987987987 10 987987987 30 987654321 30 987654321 20 888665555 20 35 5 20 15 16 rows selected. SQL> select * from jps. dependent; ESSN DEPENDENTNAME SEX BDATE RELATIONSHIP 333445555 Alice 333445555 Theodore 333445555 Joy 987654321 Abner 123456789 Michael 123456789 Alice 123456789 Elizabeth F M F M M F F 05-APR-76 Daughter 25-OCT-73 Son 03-MAY-48 Spouse 29-FEB-32 Spouse 01-JAN-78 Son 31-DEC-78 Daughter 05-MAY-57 Spouse 7 rows selected. > SQL> describe jps. employee; Name Null? Type NAME SSN BDATE SEX SALARY SUPERSSN DNO NOT NULL VARCHAR2 (19) NOT NULL CHAR (9) DATE CHAR (3) NUMBER (8,2) CHAR(9) VARCHAR2 (8) SQL> describe jps. department; Name Null? Type DNAME DNUMBER MGRSSN MGRSTARTDATE NOT NULL VARCHAR2 (15) NOT NULL VARCHAR2 (8) CHAR (9) DATE SQL> describe jps. project; Name Null? Type PNAME PNUMBER PLOCATION DNUM NOT NULL VARCHAR2 (15) NOT NULL VARCHAR2 (8) VARCHAR2 (15) VARCHAR2 (8) SQL> describe jps.deptlocation; Name Null? Type DNUMBER DLOCATION NOT NULL VARCHAR2 (8) NOT NULL VARCHAR2 (15) SQL> describe jps.workson; Name Null? Type ESSN PNO HOURS NOT NULL CHAR (9) NOT NULL VARCHAR2 (8) NUMBER (5,1) SQL> describe jps. dependent; Name Null? Type ESSN DEPENDENTNAME SEX BDATE RELATIONSHIP NOT NULL CHAR (9) NOT NULL VARCHAR2 (15) CHAR (3) DATE VARCHAR2 (12)