Hi
My DB has got 3 tables (Employee, JobHistory , Activity) at the end of every month, activity of employee and his/her job situation will be inserted ..
My tables and relationships are:
Employee (PK: Person_No)
JobHistory(FK: Person_No)
Activity (FK: Person_No)
But i think in this design, there would be data dupication especially in Activity Table , each employee has at least one record in Activity table every month, that would be plenty of records after one year ..
any idea about better design ?