Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2014
    Posts
    5

    Question Employees Evaluation System

    Hello everybody
    I am new to database designing
    I want to design an Employees Evaluation System for a company using ASP.NET
    Based on Competencies Rating

    Each Manager will rate his/her employees at the end of each year for 6 standard competencies such as (Teamwork, Learning, Communication, etc)
    5. Outstanding 200% of competencies
    4. Exceed 150% of competencies
    3. Achieve 100% of competencies
    2. Need Improvement 70% of competencies
    1. Under Performance 50% of competencies
    Then both employee and manager should agree and confirm this rating.
    Also I would like to save each rating for the next years.

    How can I build the database?
    Employee table
    Rating Table
    ??

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    To start; try and name all of your entities.
    Quote Originally Posted by HalF_MooN View Post
    Employee
    Rating
    This is a good start.
    However "rating" is a bit vague.
    Are you meaning "employee rating", "competency rating", etc?
    George
    Home | Blog

  3. #3
    Join Date
    Jul 2014
    Posts
    5
    Quote Originally Posted by gvee View Post
    To start; try and name all of your entities.

    This is a good start.
    However "rating" is a bit vague.
    Are you meaning "employee rating", "competency rating", etc?

    employee rating
    and this table include 6 competencies for example listing from 5 to 1 on each competency

    what do you think of the database in the attachments ?
    Attached Thumbnails Attached Thumbnails rating_system.jpg  

  4. #4
    Join Date
    Jul 2014
    Posts
    5
    Quote Originally Posted by gvee View Post
    To start; try and name all of your entities.

    This is a good start.
    However "rating" is a bit vague.
    Are you meaning "employee rating", "competency rating", etc?

    employee rating includes 6 competencies such as teamwork under the teamwork will be a list from 5 to 1

    what do you think of the database in the attachment?
    Attached Thumbnails Attached Thumbnails rating_system.jpg  

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    more than 100% 'comptantices, what on earth does that mean

    either they are competent... so score 100%, or they are not score <100%.

    what is the role of RID
    can an employee have more than one set of competency ratings, if so you may want to think about how you record when the assessment was done
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Jul 2014
    Posts
    5
    Again thank you all for helping me and sorry I am new to database

    Quote Originally Posted by healdem View Post
    more than 100% 'comptantices, what on earth does that mean

    either they are competent... so score 100%, or they are not score <100%.
    the scores is applied to 2 ratings: competencies and objectives because of that its a little bit confusing , I will build other function to store objectives and rate them as the competencies but its complicated.

    I want to complete the competencies system first.


    what is the role of RID
    can an employee have more than one set of competency ratings, if so you may want to think about how you record when the assessment was done
    The employee and the manager in the beginning of the year should confirm that they met together so I created the approval table

    The employee will have only one competencies rating in the end of December each year
    I added R_ID to store it for the next year. ? should I use only the emp ID as promary key and use the date ?? is there a better way ?

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    so you are adding together ratings, and presumably the highest rating an employee could get is 100% in each of the 4 categorries, and overall ranking of, say 400 (% in this context is meaningless).

    or you would weight each category to come up with a combined mark.. the baseline would presumably 25% for each of the 4 categories... ie sum of ratings / number of ratings


    I added R_ID to store it for the next year. ? should I use only the emp ID as promary key and use the date ?? is there a better way ?
    I don't see what role R_ID has in this scenario. it has the hallmarks of an autogenerated key stuck in the table for no real purpose. I guess it depends on your requirement. is their one assessment once per year/time period. do all the gradings happen on the same day (ie whould there b one row per grading type or 4 gradings in one row
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Jul 2014
    Posts
    5

    Question

    Quote Originally Posted by healdem View Post
    so you are adding together ratings, and presumably the highest rating an employee could get is 100% in each of the 4 categorries, and overall ranking of, say 400 (% in this context is meaningless).

    or you would weight each category to come up with a combined mark.. the baseline would presumably 25% for each of the 4 categories... ie sum of ratings / number of ratings




    I don't see what role R_ID has in this scenario. it has the hallmarks of an autogenerated key stuck in the table for no real purpose. I guess it depends on your requirement. is their one assessment once per year/time period. do all the gradings happen on the same day (ie whould there b one row per grading type or 4 gradings in one row
    Thank you for helping me.

    Each competency will be rated separately ONCE a year
    for example:
    Teamwork >> Outstanding
    Communication >> Need Improvements
    etc

    I would like to ask what if I have 2 groups of competencies assigned to different groups of employees
    Group 1: competencies for regular employees
    Group 2: Other competencies for managers


    should I create two separate tables for each group of employees ?
    see attachments
    Attached Thumbnails Attached Thumbnails Rating_system_2.jpg  

Tags for this Thread

Posting Permissions

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