>If you don't agree to this statement, please tell me how you would solve the problem above.

Simple, the entire problem is created by your habit of using real-world keys as primary keys. Use surrogate keys, and you don't have the problem.