471,122 Members | 1,180 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,122 software developers and data experts.

Need help with table normalization please

I'm developing and HR database with Access 2010. I've hit a snag with designing a Performance Evaluation table.

I have various lookup tables for:

PerformanceRatingID (eg. Average, Outstanding)
EvaluationAreaID (eg. Attendance, Housekeeping)

Each employee will have multiple evaluations from different supervisors. Each evaluation will contain contain a rating of several EvaluationAreas.

I'm trying to figure out how to identify a single record that contains these multiple evaluations by one supervisor. I'm thinking I need to use a composite key but I'm not 100% clear on how to go about it.

Alternately, I could hardcode all of the evaluation areas into the Performance table but that seems wrong to me.

Am I overthinking? Any perspective/comments/suggestions would be appreciated.
Aug 29 '13 #1
4 878
Seth Schrock
2,965 Expert 2GB
It is difficult to say with so little information, but I would stay away from composite keys if possible, especially if it would be more than two fields. Instead just add an autonumber field to be the Primary Key. If you are then looking for the evaluations by one supervisor, then you just select that supervisor's ID in the WHERE clause of your query.
Aug 30 '13 #2
12,516 Expert Mod 8TB
You wouldn't want to store the multiple evaluations in a single record. If you want to view multiple evaluations as a single record, you can just use a cross tab query. But I would still store it as multiple records.
Aug 30 '13 #3
I did think of a crosstab query after I posted. I think you're right that once I isolate the SV, Employee and date of evaluation, I'll get the appropriate record.
thanks so much for your input.
Sep 3 '13 #4
12,516 Expert Mod 8TB
No problem. Let us know how you get along and if you have trouble setting up the crosstab.
Sep 3 '13 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Roamer | last post: by
5 posts views Thread by Kissi Asiedu | last post: by
4 posts views Thread by lorirobn | last post: by
1 post views Thread by =?ISO-8859-1?Q?S=F8ren?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.