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.

$\backslash$table$[[\backslash$table$[[$Project$],[$Code$]],\backslash$table$[[$Project$],[$Name$]],\backslash$table$[[$Project$],[$Manager$]],\backslash$table$[[$Project$],[$Budget$]],\backslash$table$[[$Employee$],[$No$.]],\backslash$table$[[$Employee$],[$Name$]],\backslash$table$[[$Dep artment$],[$No$.]],\backslash$table$[[$Dep artment$],[$Name$]],\backslash$table$[[$Hourly$],[$Rate$]]],[$PC $010,\backslash$table$[[$Reservation$],[$System$]],$Mr$.$ Ajay,$120500,$S$100,$Mohan,D$03,$Database,$21\mathrm{.}00],[$PC $010,\backslash$table$[[$Reservation$],[$System$]],$Mr$.$ Ajay,$120500,$S$101,$Vipul,D $02,$Testing,$16\mathrm{.}50],[$PC $010,\backslash$table$[[$Reservation$],[$System$]],$Mr$.,120500,102,$Riyaz,D$01,$IT$,22\mathrm{.}00],[$PC $011,$HR System,Mrs$.$ Charu,$500500,$S$103,$Pa$,$D$03,$Database,$18\mathrm{.}50],[$PC$011,$HR System,Mrs$.$ Charu,$500500,$S$104,$Jitendra,D$02,$Testing,$17\mathrm{.}00],[$PC$011,$HR System,Mrs$.$ Charu,$500500,$S$315,$Pooja,D$01,$IT$,23\mathrm{.}50],[$PC $012,\backslash$table$[[$Attendance$],[$System$]],$Mr$.$ Rajesh,$710700,$S$137,$Rahul,D$03,$Database,$21\mathrm{.}50],[$PC $012,\backslash$table$[[$Attendance$],[$System$]],\backslash$table$[[$M$.$ Rajesh$]],710700,18,$vneesh,D$02,$esting,$15\mathrm{.}50],[$PC $012,\backslash$table$[[$Attendance$],[$System$]],$M$.$ R$,710700,$S$109,$Vikas,D$01,$IT$,20\mathrm{.}50]]$

a$.$ Explain the structure of the table in the First Normal Form.

b$.$ Draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data shown.

c$.$ Develop a set of relations in the Second and Third Normal Forms.

d$.$ Draw your answer to part c using

app.diagrams.net tool, save as an image and insert into this file.

Solution.