Table Setup

[pd06498]

I am putting together a database to record staff performance appraisals.

I am a little stumped as to the best way to go about setting the following part up, and was wondering if someone could give me some ideas.

I have a main table which records each employees details. I also have a table that records the dates each employee undergoes an appraisal (each employee will have several appraisals over a period of a year). Within each appraisal, I want to record the criteria each employee is appraised under. Some employees might have 3 or 4 criteria, while others might have more, depending on their seniority. Within each criteria I want to record the results of each appraisal. For instance, on date1, an employee is appraised and rated against 4 criteria, and next time they are appraised, they are again rated on similar criteria using the same rating scale.

Is anyone able to give me some clues on how to best set these tables up?

 

[KenHigg]

Are you still in need of help on this?

 

[pd06498]

Yes please!

 

[Mile-O]

Just a quick suggestion.

tblEmployees
EmployeeID
Forename
Surname
...
(I don't know what other employee details you'd want to store)

tblAppraisals
AppraisalID
DateOfAppraisal

tblEmployeesToAppraisals
EmployeeID
AppraisalID
CategoryID
Score

tblCategories
CategoryID
Category

 

[KenHigg]

Q1. Is there an employee classification, (salesman, manager, etc.) that will each have a set of criteria or will you just be pick the review criteria at the time of the review.
Q2. Do you want the db to record and track the review dates or do you want to keep up with them separately?