ENCORE HYDRAULICS DEPARTMENT STAFFING REPORT DEPT NO: 100 DEPT NAME: Administration MANAGER: Simon Semple EMP NO: 48 LOCATION: 1991 Leslie, Toronto EMP NAME EMP NO POSITION CODE POSITION Nadia Betz 22 C Clerk Raoul Radniski 12 A Accountant John Smith 14 S Supervisor Raj Singh 31 C Clerk DEPT NO: 200 DEPT NAME: Hydraulics MANAGER: A. Martinez EMP NO: 16 LOCATION: 1241 Main St, Ajax EMP NAME EMP NO POSITION CODE POSITION Lee Goldman 25 E Engineer Paul Prentiss 15 E Engineer Leah Zeltserman 36 EA Engineering Assistant Mark Wong 8 S Supervisor … Normalize the above user view. Document all steps including unnormalized, first normal form, Dependencies, second normal form, and third normal form.
ENCORE HYDRAULICS DEPARTMENT STAFFING REPORT
DEPT NO: 100 DEPT NAME: Administration
MANAGER: Simon Semple EMP NO: 48 LOCATION: 1991 Leslie, Toronto
EMP NAME EMP NO POSITION CODE POSITION
Nadia Betz 22 C Clerk
Raoul Radniski 12 A Accountant
John Smith 14 S Supervisor
Raj Singh 31 C Clerk
DEPT NO: 200 DEPT NAME: Hydraulics
MANAGER: A. Martinez EMP NO: 16 LOCATION: 1241 Main St, Ajax
EMP NAME EMP NO POSITION CODE POSITION
Lee Goldman 25 E Engineer
Paul Prentiss 15 E Engineer
Leah Zeltserman 36 EA Engineering Assistant
Mark Wong 8 S Supervisor
…
Normalize the above user view. Document all steps including unnormalized, first normal form, Dependencies, second normal form, and third normal form.
Step by step
Solved in 2 steps
