please solve part no 2 and 3

Thankyou

Normalize the database below 1. Explain the structure of the table in the First Normal Form. 2. Draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data shown. 3. Develop a set of relations in the Second and Third Normal Forms. Create your solution in app.diagrams.net online tool, save your solution as an image, insert the image in this MS Word file and it to the week 6 Database Interrogation Assessment in Canvas before the end your class. Task. The table below represents the following information: Information about a project: a project code, a project name, a project manager name and a project budget Several employees can work on a project. The table stores an employee number, an employee name, an employee's department number and a department name, and an employee's hourly rate. Project Project Project Project Employee Employee Department Department Hourly Code Name Manager Budget No. Name No. Name Rate PC010 Reservation Mr. Ajay 120500 S100 Mohan D03 Database 21.00 System PC010 Reservation Mr. Ajay 120500 S101 Vipul DO2 Testing 16.50 System PCO10 Reservation Mr. Ajay 120500 S102 Riyaz DO1 IT 22.00 System PC011 HR System Mrs. Charu 500500 S103 Pavan D03 Database 18.50 PC011 HR System Mrs. Charu 500500 S104 Jitendra D02 Testing 17.00 PC011 HR System Mrs. Charu 500500 S315 Pooja D01 IT 23.50 PC012 Attendance M. Rajesh 710700 $137 Rahul DO3 Database 21.50 System PC012 Attendance Mr. Rajesh 710700 $218 Avneesh DO2 15.50 System PC012 Attendance Mr. Rajesh 710700 S109 Vikas IT 20.50 System Testing DO1