Multiple Assignments - long term approach
One person has only one personnel number
- Person related data will be stored only once. There will be no data redundancy.
The approach presupposes changes in the HR data model
- The relationship person : multiple assignments will be handled by an own relationship table.