Sergiy (3/17/2010)

---

I'm afraid you're wrong with you requirements.

🙂

These 2 statements contradict each other:

On the other side an Oracle DB, also with staff, but only active.

when a staff member leaves and comes back, the key will always stay the same on the Oracle-side.

When a staff member leaves then it must be deleted from Oracle database because it holds only active ones.

When the same staff member comes back the old key should be gone, and therefore there is no way to re-assign it to this staff member.

Something is wrong in the task description.