Forum Discussion
Multi-level constraints
eli_kent If I understand the question correctly, the attached ER diagram should meet the requirements. Workers have one trade and a trade is associated with a skill.
Hi, and thanks for taking this on!
Firstly, can you kindly paste the diagram into the body of the message? My employer has a strict policy about opening files.
Secondly, to clarify, workers have one or more trades, and trades can have zero specific skills/specifications or can have one or more.
So Mike (worker) could be a carpenter (trade) with no special skills/specifications.
Bob (worker) could be a laborer (trade) who knows how to use a pile driver (skill) and an operator (trade) who knows how to use a digger (skill) and a crane (skill)
Barbara (worker) could be an electrician (trade) with a master certificate (skill)
I hope that makes it more clear.