SQL allows a foreign-key dependency to refer to the same relation, as in the following example:
Here, employee_name is a key to the table manager, meaning that each employee has at most one manager. The foreign-key clause requires that every manager also be an employee. Explain exactly what happens when a tuple in the relation manager is deleted.