Design for default field value based on n # of criteria

Last Post 27 Jun 2002 07:34 AM by Bharilal. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Bharilal
New Member
New Member

--
27 Jun 2002 07:34 AM

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!

You are not authorized to post a reply.

Acceptable Use Policy