The given relation PROJECT_DETAILS has to be normalized step-by-step. For each normal form, the FD diagram has to be drawn. The dependencies and anomalies have to be briefed.

Project Employee Project Employee Department Department Hourly Project Title Name Code No Name No Rate Budget A Smith S10001 L004 22.00 Pensions L Jones L023 Pensions 18.50 24500 PC010 S10030 System P Lewis S21010 L004 21.00 B Jones 21.75 S 10010 L004 IT PC045 S 10001 Salaries A Smith L004 18.00 17400 S3 1002 System TGilbert L028 Database 25.50 S13210 W Richards L008 Salary 17.00 T Gilbert L028 Database 23.25 S3 1002 PC064 S21010 HR System P Lewis L004 IT 17.50 12250 S1 0034 16.50 B James L009 HR