1) For the following figure, please indicate all the referential integrity constraints.

a. EMPLOYEE.DNO references to DEPARTMENT.DNUMBER

b. DEPARTMENT.MGRSS references to EMPLOYEE.SSN

c. EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN

d. All of a, b, and c.

2) indicate the pair to form the mutual recursive referential integrity constraints

a)EMPLOYEE.DNO references to DEPARTMENT.DNUMBER

DEPARTMENT.MGRSS references to EMPLOYEE.SSN

b) EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN

EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN

c) DEPARTMENT.MGRSS references to EMPLOYEE.SSN

EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN

d) EMPLOYEE.DNO references to DEPARTMENT.DNUMBER

EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN

3) indicate the recursive referential integrity constraint.

a. EMPLOYEE.DNO references to DEPARTMENT.DNUMBER

b. DEPARTMENT.MGRSS references to EMPLOYEE.SSN

c. EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN

d. All of a, b, and c.

EMPLOYEE FNAME MINTLNAME SSN BDATE SEX SALARY SUPERSSN DNO DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE