Question: For the following figure, please indicate all the referential integrity constraints. INAME MINAN DATE SALAMMUN ONO DERNE DINAMB DNUMBER MANGRYTARTOATE All of a, b, and



For the following figure, please indicate all the referential integrity constraints. INAME MINAN DATE SALAMMUN ONO DERNE DINAMB DNUMBER MANGRYTARTOATE All of a, b, and a. EMPLOYEE.DNO references to DEPARTMENT.DNUMBER b. DEPARTMENT.MGRSS references to EMPLOYEE SSN C. EMPLOYEE SUPERSSN references to EMPLOYEE SSN For the following figure, please indicate the pair to form the mutual recursive referential integrity constraints NAME MINT ENAME SALARY SUPERMAN DEPARTMENT DINAME NUMBER MGRSNMGRYTARTDATE EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN EMPLOYEE.DNO references to DEPARTMENT.DNUMBER DEPARTMENT.MGRSS references to EMPLOYEE.SSN DEPARTMENT.MGRSS references to EMPLOYEE.SSN EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN EMPLOYEE.DNO references to DEPARTMENT.DNUMBER EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN For the following figure, please indicate the recursive referential integrity constraint. EMPLOYEE PNAME MINT INAME IN DATE SALARY SUPERSSN DNO DEPARTMENE DNAME DNUMBER MGREN MORSTARTDATE a. EMPLOYEE.DNO references to DEPARTMENT.DNUMBER C. EMPLOYEE.SUPERSSN references to EMPLOYEE.SSN b. DEPARTMENT.MGRSS references to EMPLOYEE.SSN All of a, b, and c
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
