Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    225

    Unanswered: Appraisal Database Help

    i need to construct a database to store info for the appraisal system which is going to start at our company in the near future...

    but am not too sure how to go about this looking at the form i have attached.

    i think that i should have a table full of the employee's details and also a table of deparments, and also a table of Job Titles...

    but after that i am a little unsure....

    you will see that there are a number of sections to the appraisal, would it be best to have all these sections in one table or in seperate tables.

    advice please

    cheers

    Andy
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2002
    Location
    Amsterdam
    Posts
    8
    I would create, at first sight, the following tables:
    • tblDepartments
    • tblJobTitles
    • tblAppraisalItems
    • tblDescriptions
    • tblItemDescriptions
    • tblAppraisalMain
    • tblAppraisalMainFirstItems
    • tblAppraisalMainSecondItems
    • tblAppraisalMainOtherItems


    tblDepartments
    strdepartmentid
    strdepartment
    recordstatus
    lastmodtime
    lastmoduser

    tblJobTitles
    strtitleid
    strtitlename
    recordstatus
    lastmodtime
    lastmoduser

    tblAppraisalItems
    lngitemid
    stritemname
    memitemdescription
    recordstatus
    lastmodtime
    lastmoduser

    tblDescriptions
    lngdescriptionid
    strdescriptionname
    intrate
    recordstatus
    lastmodtime
    lastmoduser

    tblItemDescriptions
    lngitemid
    lngdescriptionid
    recordstatus
    lastmodtime
    lastmoduser

    tblAppraisalMain
    lngappraisalid
    strname
    strappraiser
    strdepartmentId
    strtitleid
    strtimeinjob
    recordstatus
    lastmodtime
    lastmoduser

    tblAppraisalMainFirstItems
    lngappraisalid
    lngitemid
    memcomments
    recordstatus
    lastmodtime
    lastmoduser

    tblAppraisalMainSecondItems
    lngappraisalid
    lngitemid
    recordstatus
    lastmodtime
    lastmoduser

    tblAppraisalMainOtherItems
    lngappraisalid
    lngitemid
    memcomments
    recordstatus
    lastmodtime
    lastmoduser

    (...)

    Create a default report and a module which rebuilds the default report to the user/company needs.

  3. #3
    Join Date
    Oct 2002
    Location
    Amsterdam
    Posts
    8
    Well found no editing option

    But I forgot in "tblAppraisalMainSecondItems" the field "intvalue"

  4. #4
    Join Date
    Mar 2003
    Posts
    225
    thanks for your reply,

    i have started very briefly to put this together, but am a little lost at how i am going to display each section within the table....

    for example in section 1

    i have the following Question :

    http://members.lycos.co.uk/redtilefc/qestion1.jpg

    it is split into a number of sections

    the Actual question

    1) APPLICATIONConsider/discuss the energy and attentiongiven to work. Is it consistent or is the work carried out in fits and starts?

    then

    the Answer and Scoring

    Outstanding. Keen & enthusiastic. Sustained effort. 5
    Applies self steadily & attentively. 4
    Works consistently but without enthusiasm. 3
    Below standard. Not always diligent or attentive. 2
    Unsatisfactory. Half hearted & indifferent. 1

    and then the Comments Box, i am just a little unsure of teh best way to put this into my table.

    my table named tbl_appraisal contains:

    tbl_Appraisal
    AppraisalID (PK)
    AppraisalDate
    AppraisalStartTime
    AppraisalEndTime
    EmployeeID - (to link to the relevant employee)

    cheers

    Andy

Posting Permissions

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