Full Version: Quick Normalization question
UtterAccess Discussion Forums > Microsoft® Access > Access Tables + Relationships
Suzee
Working on a new project from scratch and since it's going to be large when I am finished I want to be sure I build everything correctly from step one.
The database is basically to track and report stats for productivity, quality and teamwork scores at the section, dept and national level for employees.

As a started putting this together this morning I'm wondering if I have a normalization issue starting already. I have attached a screen shot of the tables and relationships. I started second guessing myself right away though...should I have all managers regardless of levels included in one employee table and then add their title as their job description?

Any input would be greatly appreciated!
preston
Yes, they should all be on one table. You could use an inner join on ManagerNo to EmpID to create the employee/manager relationships.
Suzee
That's what I was thinking as soon as I laid out the relationships this morning. Thank you so much for taking a few minutes to peek at it for me!!
preston
you're most welcome!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.