Don't delete record from
employee table. Update Flag on particular employee.
DELETE FROM Employee WHERE Employee_ID='EMP001'
Employee
-----------
Employee_ID
Employee_Name
Active
Employee_Job
-----------
Assigned_Person
Job_ID
Job_Name
Status
When you want to delete an employee from table Employee, just update status for Active column for that particular employee.
UPDATE Employee SET Active='N' WHERE Employee_ID='EMP001'
If you want show only Active employees then use the below query(it won't show deleted employees)
SELECT * FROM Employee WHERE Active='Y'