I'm in the process of designing a database and would like some
suggestion on how to architect it.
I have 3 'objects', frequency, task, skill.
For each task there is a frequency however for some tasks there are a
number of different skills, each of which have different frequencies,
so, for example, imagine frequencies being time in minutes. Each task
has to be done a certain number of times but certain tasks have varied
skill levels and each skill level has different frequencies associated
with it.
Task 1, Freq 5min
Task 2, Freq 10min
Task 3, Skill 1, Freq 5min
Task 3, Skill 2, Freq 15min
Task 4, Skill 1, Freq 10min
Task 4, Skill 2, Freq 15min
Task 4, Skill 3, Freq 20min
The problems is that the freq / skill is dependent on the task. I'm
having trouble deciding how to build this database.
I could just hard code the Tasks/Skill in a table so that I have
TaskID PK
Task
Freq
and have records like:
1 Task1 5
2 Task2 10
3 Task3Skill1 5
4 Task3Skill2 15
but I don't like it because it is not easily maintained - in case
freq/skills change.
Does anyone have any ideas. The important information is the
frequency as it will be used to build timetables.