Currently I am working on creation of database that stores information about employees in my company. The main problem which I have encountered is changing statuses of employees and tracking those changes in a way that will enable to report them later in easy manner. Let me give an example:
I have table Employees with team in which employee is currently working. I have also a table storing changes of teams where historical states of team assignation is contained. How can I improve that design?
Imagine that I want to prepare report in which for all months in current year number of employees will be evaluated in different teams. With current design it seems to me quite complicated, how may I improve that design or easily deliver such report with current design?
Database9.zip