Results 1 to 10 of 10
  1. #1
    Join Date
    Jan 2005
    Posts
    8

    please verify my payroll data model (was "Schema")

    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...
    Attached Thumbnails Attached Thumbnails Schema.png  

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    BonusConge is a repeating group. It violates first normal form.

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

  3. #3
    Join Date
    Dec 2004
    Posts
    54

    Payroll

    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

  4. #4
    Join Date
    Jan 2005
    Posts
    8

    Talking same model

    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.

  5. #5
    Join Date
    Jan 2005
    Posts
    8

    Talking pls pay attention

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

  6. #6
    Join Date
    Dec 2004
    Posts
    54

    Hi

    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
    Attached Thumbnails Attached Thumbnails BetterStartPayWork.gif  

  7. #7
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Here is a suggested alternate model:
    Attached Thumbnails Attached Thumbnails untitled.JPG  
    Last edited by certus; 01-26-05 at 04:59.

  8. #8
    Join Date
    Jan 2005
    Posts
    8

    Red face same 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.

  9. #9
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    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.

  10. #10
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    At least that is what I gleaned for business rules from your model

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •