Boy it's hard to tell here. An 'operator' is a person in a role and I wouldn't directly relate them to a machine. I'm not certain what a 'BonusConge' is, but it's not normalized. What will you do when Qa25 comes along?
firt, i just wanna say thanks to certus and vmusic for this quick post.
my english is not good forgive me.
'BonusConge' is a table created to receive amount for each operator every 15 days, because we have payroll in every 15 days.
Qz1 receive the amount between : 01 jan to 15 jan ex. Qz1=$300
qz2 receive the amount between : 16 jan to 31 jan ex. Qz1=$400
and at the end of the year we'll use those amount to calculate :
boni + Vaccation leave
Boni is the compilation of all amount for 1 year divide by 12
Vaccation is the result of Boni divide by 2.
An operator is a person working on a machine and it's possible that opeartor know many machines.
It looks, and again it's hard to tell, like your 1) need to track the time each person works on a machine then 2) convert that to a payroll
There are many "work-effort" models out there available. Make it generic, because what if they are perform some other task that is not working on a machine - do they not get paid? Like maintenance or other downtime.
I attached a conceptual model... it may not be exactly correct, but it should help to get you thinking a little better about work effort.
thanks for the last one i 've found very good but i wonder me instead table Operator it would be table Payroll. One question <<What happening if i want to add a new operator?>>i've got no Operator table .
May introduce the Operator table ? once again you're help will be very appreciate.