The table below represents the following information:

Information about a project: a project code, a project name, a project manager name

and a project budgetSeveral 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.

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,