DELETE FROM department WHERE department$\_$no$=2$;

As you delete the contents of department$\_$no $=2$ in the department table it automatically deletes the details of department$\_$no$=2$ from the employee table also. This works out because the foreign key constraint ON DELETE CASCADE is specified

$14.$ Convert the ER schema for Bank database given below into a relationd schema.