Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please write out new tables for 1NF,2NF,3NF. Thanks! Convert into 1NF, 2NF and 3NF Project Title Project Code PC010 Project Manager M Phillips Project Budget
Please write out new tables for 1NF,2NF,3NF. Thanks!
Convert into 1NF, 2NF and 3NF Project Title Project Code PC010 Project Manager M Phillips Project Budget 24500 Employee No. S10001 Employee Name A Smith Department No. L004 Department Hourly Name Rate 22.00 PC010 M Phillips 24500 S10030 LJones L023 Pensions 18.50 PC010 M Phillips 24500 P Lewis L004 IT 21.00 PC045 H Martin S21010 S10010 S10001 B Jones L004 IT 17400 17400 21.75 PC045 H Martin A Smith L004 IT 18.00 Pensions System Pensions System Pensions System Salaries System Salaries System Salaries System Salaries System HR System HR System HR System Pensions System PC045 H Martin 17400 531002 T Gilbert L028 Database 25.50 PC045 H Martin 17400 S13210 W Richards L008 Salary 17.00 I PC064 PC064 PC064 PC010 K Lewis K Lewis K Lewis M Phillips 12250 12250 12250 24500 S31002 S21010 S 10034 T Gilbert P Lewis B James A Smith LO28 L004 L0091 L004 Database IT HR 23.25 17.50 16.50 22.00 Pensions S21010 S10010 LJones P Lewis B Jones LO23 L004 L004 18.50 21.00 21.75 PC045 H Martin 17400 Salaries System PC064 HR System K Lewis 12250 S10001 S31002 S13210 S31002 S21010 S10034 A Smith T Gilbert W Richards T Gilbert P Lewis B James L004 L028 LO08 L028 L004 L009 Database Salary Database IT HR 18.00 25.50 17.00 23.25 17.50 16.50 LStep 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