Question: Convert the table into 1NF, then 2NF, then 3NF. Please explain the answers. What should one consider to make this process easier to understand? Homework

 Convert the table into 1NF, then 2NF, then 3NF. Please explain

Convert the table into 1NF, then 2NF, then 3NF.

Please explain the answers. What should one consider to make this process easier to understand?

Homework 5-5 Convert into 1NF, 2NF and 3NF Project Project Title Project Project Employee Employee Depertment Department Houriy PCO1O Pensions PCO10 Pensions Manager Budget No Name M Phiips 24500 M Philips 24500 M Philips 24500 S21DI0 P Lewis 510001 A Smith S10030 L Jones 023 Penions 18.50 CO10 Pensions C045 Salanes PC045 Salaries 004 IT 21.00 17400 S10010 H Martin H Martin 17400 H Martin 17400 S31002 TG B Jones 21.75 S10001 A Smith System IT 18.00 Database 25.50 PC045Salaries Martin 17400 13210 W Richards Salary 17.00 Database 23 008 Pc064 HR System KLewis 12250 $31002 Gbert PC064 HR System K Lewis 12250 $10034 BJames 028 004 009 .004 Co64 HR System K Lewis 12250 S21010P LEW IT17.50 6.50 HR CO10Pensions M Phillips 24500 S10001 A Smith 22.00 System 10030L Jones P Lewis 023 Pensions LT 18.50 C045Salaries Systerm 521010 | S10010 004 004 H Martin 17400 | B Jones 21.75 S31002 S13210 T Gilbert W Richards T Gilbert 028 008 028 004 009 25.50 Salary 17.00 Database 23.25 Database 064 HR System : K Lewis | 12250-31002 S21010 PLewis S10034 BJames IT 17.50 HR16.50

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!