Please help me to undestand the best design to tackle this recurring problem.
I have a EMPLOYEE_MASTER table with the following structure. EMP_DESIGNATION may change over time. I want to keep the history of such changes for future references. What is the most efficient approach to store designation here? Should I move it to another table with an effective start date and end date?