Please help! Will upvote if correct

Question $1)(10$ points$)$

In this question, you will delve deeper into the principles of database normalization by working

with a more complex denormalized table. Your task is to transform the given denormalized table

into relations that adhere to the first, second, and third normal forms $(1NF,2NF,$ and $3NF$

respectively$).$

The following table represents information about employees, their departments, projects they

are assigned to$,$ and the tasks associated with those projects:

We have the following functional dependencies present in this table:

$($Employee ID$)($Employee Name, Department ID$)$

$($Department ID$)($Department Name$)$

$($Project ID$)($Project Name$)$

$($Task ID$)($Task Description$)$

$($Employee ID$,$ Project ID$,$ Task ID$)($Task Start Date$)$

Your tasks:

If the table is not in First Normal Form $(1$NF$),$ convert it into $1NF.$ What is the primary key in

the $1NF$ table.

Convert the $1NF$ table into Second Normal Form $(2$NF$).$

Convert the $2NF$ table into Third Normal Form $(3$NF$).$

Solution Submission Guidelines for Question $(1)$:

Submit your assignment containing the following:

Normalized tables for $1NF,2NF,$ and $3NF.$

A brief explanation of the normalization process you followed for each normal form.

You can complete this question in an Excel file and submit the Excel file.