Here is my business requirement.
I have employees in a company and they all have goals and these goals have default targets. Default targets are based on n number of criteria. For example, an employee who belongs to a specific business unit and thier rank is VP would have a default target based on that for a specific goal. But for another type of goal, target may be determined only by business unit.
In my database, I would need to have a Goal Table and GoalTarget table. The Goal Table would contain the specific goals. The GoalTarget table would contain the targets based on Goal and n number of criteria.
The problem I have is that I do not want to represent the criteria by columns in that table because the criteria are always changing and if there is a new criteria, I would have to add that field to the table. I would like to be able to add a new criteria without affecting the datamodel.
What would be a good data model to support this requirement?
Thanks in advance!