This is a simple list table of a company trying to keep track of employee assignment to company projects (in other words, not a database but a flat one table file). You will design a database for this company so that they won't be relying on a simple 1 table list system to keep track of their data. Looking at the table below, produce the 3NF of the data.
Project Code,Project Name,Project Manager,Project Budget,Employee No.,Employee Name,Department No.,Department Name,Hourly Rate
PC010,Reservation System,Mr. Ajay,120500,S100,Mohan,D03,Database,21.00
PC010,Reservation System,Mr. Ajay,120500,S101,Vipul,D02,Testing,16.50
PC010,Reservation System,Mr. Ajay,120500,S102,Riyaz,D01,IT,22.00
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 System,Mr. Rajesh,710700,S137,Rahul,D03,Database,21.50
PC012,Attendance System,Mr. Rajesh,710700,S218,Avneesh,D02,Testing,15.50
PC012,Attendance System,Mr. Rajesh,710700,S109,Vikas,D01,IT,20.50