For the following six tables:

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

B) List the primary key and all the foreign keys in each table.

C) Based on each pair of primary key and foreign key, given in B above, 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.

1) TABEL EMPLOYEE

Name Null? Type

----------------------------------------- -------- ----------------------------

NAME NOT NULL VARCHAR2(19)

SSN NOT NULL CHAR(9)

BDATE DATE

SEX CHAR(3)

SALARY NUMBER(8,2)

SUPERSSN CHAR(9)

DNO VARCHAR2(8)

2) Table department

Name Null? Type

----------------------------------------- -------- ----------------------------

DNAME NOT NULL VARCHAR2(15)

DNUMBER NOT NULL VARCHAR2(8)

MGRSSN CHAR(9)

MGRSTARTDATE DATE

3) Table project

Name Null? Type

----------------------------------------- -------- ----------------------------

PNAME NOT NULL VARCHAR2(15)

PNUMBER NOT NULL VARCHAR2(8)

PLOCATION VARCHAR2(15)

DNUM VARCHAR2(8)

4) TABLE DEPTLOCATION

Name Null? Type

----------------------------------------- -------- ----------------------------

DNUMBER NOT NULL VARCHAR2(8)

DLOCATION NOT NULL VARCHAR2(15)

5) TABLE WORKSON

Name Null? Type

----------------------------------------- -------- ----------------------------

ESSN NOT NULL CHAR(9)

PNO NOT NULL VARCHAR2(8)

HOURS NUMBER(5,1)

6) TABLE DEPENDENT

Name Null? Type

----------------------------------------- -------- ----------------------------

ESSN NOT NULL CHAR(9)

DEPENDENTNAME NOT NULL VARCHAR2(15)

SEX CHAR(3)

BDATE DATE

RELATIONSHIP VARCHAR2(12)