Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Give the table of data below, normalize the data to the 3d Normal form. Project Project TitleProject Project Employee Employee Department Department Hourly Code PCO10
Give the table of data below, normalize the data to the 3d Normal form. Project Project TitleProject Project Employee Employee Department Department Hourly Code PCO10 Manager Budget No Name No Name Rate Pensions Svstem Pensions System Pensions Svstem Salaries System Salaries Svstem Salaries System Salaries System HR System M Phillips 24500 M Phillips 24500 M Phillips 24500 H Martin H Martin H Martin H Martin K Lewis S10001 S10030 S21010 S10010 S10001 S31002 S13210 S31002 A Smith L Jones P Lewis B Jones A Smith T Gilbert W Richards T Gilbert L004 LO23 L004 L004 L004 L028 008 L028 22.00 18.50 21.00 21.75 18.00 25.50 17.00 23.25 IT Pensions PCO10 PCO10 PCO45 IT 17400 17400 17400 17400 12250 IT PCO45 IT Database Salary Database PCO45 PCO45 PCO64 R System R System ewis ewis WIS mes A Smith PCO10 M Phillips 24500 Pensions System S10001 L004 IT 22.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started