hi everybody....
I've got this schema that i would someone to verify for me and let me know if i'm doing a good job.It's a payroll designing.

thanks...

BonusConge is a repeating group. It violates first normal form.

I don't know your business rules, so I prefer not to comment further.

Hi,
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?

Sorry Je n'est pas parlez francaise.

Vmusic

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.

God hope u anderstand me...
thanks for all Guys.

Just take a look with this and let me know if i'm right.
tanks a lot.

Hi Skefe,
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.

Bon Chance!
Vmusic

Here is a suggested alternate model:

hi guys...

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.

Thanks.

I saw this coming. The operateur table contains the fixed amount used in calculation not the results of the calculations:

reg_hres: This is what is regarded as the min regular hours for the operateur such as 37.5 hours.

reg_mnt: This is the regular rate of pay per hour.

ot_mnt: The is the rate of pay for overtime per hour.

sal_min: This is the minimum annual salary.

These amounts are unique to the operateur so do not require another table.

At least that is what I gleaned for business rules from your model