Hi, I have been tasked with putting together a database for 8 KPI. These KPI are measured on a weekly basis and the purpose of the database is so that it becomes easier to measure change in KPI amongst employees on a week-over-week basis.
I struggle to figure how to fit this into a relational model, but I figure something like this might do:
Three tables: KPI, Reporting_Period, Employee
Then I would make the unique identifier on the KPI table a combination of the Employee ID and the Reporting Period ID.
Does that sound rational? Is there a better way of accomplishing this?
I struggle to figure how to fit this into a relational model, but I figure something like this might do:
Three tables: KPI, Reporting_Period, Employee
Then I would make the unique identifier on the KPI table a combination of the Employee ID and the Reporting Period ID.
Does that sound rational? Is there a better way of accomplishing this?