Identify any partial dependency, transitive dependency, and full dependency relationship.

Create a relational model that makes this data arrangement 2NF.

Create a relational model that makes this data arrangement 3N.

Project Project Project Project Employee Employee Department Department Hourly Code Na me Manager Budget No. Name No. Name Rate Mohan D03 Database 21.00 PC010 Reservation Mr. Ajay System 120500 $100 PC010 Reservation Mr. Ajay 120500 $101 System Vipul Riyaz Pavan Jitendra 500500 $104 500500 $315 Pooja 710700 $137 Rahul 710700 $218 Avneesh 710700 $109 PC010 Reservation Mr Ajay 120500 $102 System PC012 Attendance Mr. Rajesh System PC011 HR System Mrs. Charu 500500 $103 PC011 HR System Mrs. Charu PC011 HR System Mrs. Charu PC012 Attendance Mr. Rajesh System PC012 Attendance Mr. Rajesh System Vikas D02 D01 D03 D02 D01 D03 D02 D01 Testing IT Database Testing IT Database Testing IT 16.50 22.00 18.50 17.00 23.50 21.50 15.50 20.50