Relationship Question: Multiple tables linked to one

[Gabriel2012]

Hello, I am building a database for a department that tracks several metrics for its employees, such as accuracy, productivty and call evaluations. The issue I am running into is that my Employee ID is the unique field I use to link all metrics, from the seperate tables, back to the individual employee, located in the "Employee" table. However when I link the tables up and begin to run quries in an attempt to combine the data from the various tables I get the cascading effect (everything is duplicated) because the employee ID is located in multiple tables, multiple times.

Below is a screen shot (it is coming across very small so my apologies, but if you paste it into Word it will show full size) of my current setup, I have tried various others as well, Any suggestions for a better layout? In all of the tables, other than the Employee ID, there are more than one entry of the employee ID since they each have multiple errors, call evaluations, etc..

[orange]

I suggest you work on you database design. Every table should have a PK. EmployeeId in the various tables would be a FK back to tblEmployee. It isn't clear from your jpg exactly what all the fields are in the various tables (since some fields are hidden by the pictorial layout of your jpg.

You seem to have other entities and Types of things- not necessarily in tables(just an observation).
Error #, Orders (web, repair, telephone...)
You certainly don't need EmployeeName in tblProductivity.
Naming conventions that allow spaces and special characters are frowned upon and WILL COME BACK TO HAUNT YOU. You should adopt a naming convention that uses alphanumerics and "_" only. It simplifies many things and often reduces errors in syntax.

Since you are "building the data base", I really suggest you get the design under control before you spend too much time "trying to program around structural issues". Having a standard set of test data (good and bad) can be very helpful for testing/reviewing any coding and structure changes.

Do you have a write up or document describing WHAT the database is about? What the major subjects are; how they interrelate? A list of Facts about the business?

[Gabriel2012]

Thank you for your reply, I have attached my layout document. Any and all suggestions are appreciated!

[orange]

I can't open you attachment -- don't know what version or encoding you have. I have Word 2003 and Word2010.

[Gabriel2012]

It will not allow me to post a .docx, so I resaved it as doc, I will try again...

[orange]

Ok I can open it now.
Is this a real problem or an assignment of some sort?
There is mention of team, bit no Entity called Team.

From the diagram it appears that 1 Supervisor "supervises" 1 employee.
What is a Call Evaluation Period?