(6 points) Consider the following constraint defined in the company database:

FOREIGN KEY (Super_ssn) REFERENCES EMPLOYEE(Ssn)

ON DELETE RESTRICT ON UPDATE RESTRICT

Answer the following questions:

1). What happens when the following command is run on the database state shown in Figure 5.6?

EMPLOYEE SET Super_ssn = 987654321WHERE Ssn = 123456789

2). Is it better to CASCADE, RESTRICT or SET NULL in case of DEPTMGRFK constraint ON DELETE and UPDATE, why?