Introduction to Databases Project $3$ Part AYou are designing a database to track information about employees and the projects they are assigned to$.$ Currently, this is the schema to describe each of the three entities:EMPLOYEE $($EmployeeNumber$,$ FirstName, LastName, Phone, Email, DepartmentName, BudgetCode, OfficeNumber, Phone$)$PROJECT $($ProjectID$,$ ProjectName, Department, MaxHours, StartDate, EndDate$)$ ASSIGNMENT $($ProjectID$,$ EmployeeNumber, HoursWorked$)$From looking at sample data, it has been determined that the following functional dependencies hold:$1)$ EmployeeNumber$->($FirstName$,$LastName,Phone,Email, DepartmentName, BudgetCode, OfficeNumber, Phone$)2)$ DepartmentName$->($BudgetCode$,$OfficeNumber,Phone$)3)$ ProjectID$->($ProjectName$,$DepartmentName,MaxHours,StartDate,EndDate$)4)($ProjectID$,$EmployeeNumber$)->($HoursWorked$,$FirstName,LastName, Phone, Email, DepartmentName, BudgetCode, OfficeNumber, Phone$)$Using the information provided, it can be seen that the EMPLOYEE entity is not properly normalized. Complete the normalization of this EMPLOYEE entity by breaking it up into two entities. Then, use paper, MySQL Workbench, Vertabelo, and$/$or Visio to draw out the database diagram $($ERD$,$ EER$)$ to describe this $4$ entity database.Submit a screenshot $($image$)$ your database diagram to receive points for Part