Create a trigger which will work before deletion in employee table and create a duplicate copy of the record in another table employee_backup.