the database design and submit the ERD use Vertabelo. Submitascreenshot$/$imageofthedatabasediagram$.$Part B $(5$ points$)$: Implement the database design in the MySQL DBMS located at itins$3.$madisoncollege.edu $($use the database that matches your username, e$.$g$.$ crice$).$ Your instructor will view the implemented database after you have submitted your project.Part C $(5$ points$)$: Insert data into the database using the provided $.$sql files, plus some new records described below. Your instructor will view the implemented database after you have submitted your project.Part D $(5$ points$)$: Query the database using the brower$-$based phpMyAdmin. Submit a text file of the queries that you executed.Part E $(10$ points$)$: Setup a PHP file in the root of your web server $($htdocs$)$ on the WAMP VM to query the database you created and display some results in an HTML table. Submit a screenshot of the HTML table displayed in the web browser include the URL in your screenshot. $1$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 A of the project. $2$Introduction to Databases Project $3$ Part BUsing browser$-$based phpMyAdmin, connect to the itins$3.$madisoncollege.edu MySQL DBMS$.$ You should then physically implement the database diagram you created in Part A into the database that matches your username $($e$.$g$.$ crice$).$Key things to check before implementing your database:$1)$ TheEmployeeNumberprimarykeyintheEMPLOYEEtableshouldbe AUTO$\_$INCREMENT. All of the other primary keys will be manually assigned when you insert data in Part C$\mathrm{.}2)$ Usethefollowingdatatypes:$$ DepartmentName $$ BudgetCode$$ OfficeNumber$$ Phone$$ EmployeeNumber $$ FirstName$$ LastName$$ Department$$ Phone$$ Email$$ ProjectID$$ ProjectName $$ Department$$ MaxHours$$ StartDate$$ EndDate$$ HoursWorkedChar$(35)$ Char$(30)$ Char$(15)$ Char$(12)$IntChar$(25)$ Char$(25)$ Char$(35)$ Char$(12)$ VarChar$(100)$ IntChar$(50)$ Char$(35)$ Numeric$(8,2)$ DateDate Numeric$(6,2)$NOTES for implementing your database: Since you used Vertabelo to create your database diagram, you should be abletogeneratetheSQLneededtoexecutewithinyourdatabase. Double$-$ check your data types first!After you submit your project, your instructor will view your implemented database by logging in to itins$3.$madisoncollege.edu to give you points for Part B$\mathrm{.}3$Introduction to Databases Project $3$ Part CIn this part, you will be inserting data into the database you implemented in Part B$.$ Complete the following steps:$1)$ CopytheINSERTINTOstatementsfromthefileprovidedcalled, InsertEmployeeData.sql and execute them in your database that you implemented in Part B$.$ You will likely need to adjust some of the INSERT INTO statements to work properly if you run one statement at a time, it will be easier to troubleshoot where any issues reside.$$ You can execute these statements using the brower$-$based phpMyAdmin$$ It is recommended that you execute them one at a time, instead of all at once this way if $($when$?)$ you run into errors you can tell which statement is causing you an error$\mathrm{.}2)$ InsertanemployeerecordforyourselfintotheEMPLOYEEtableuse your real first name and last name, the rest of the fields can be made up to your liking. Assign yourself to the InfoSystems department$\mathrm{.}3)$ InsertanewProjectrecordintothePROJECTtablewiththefollowing info:$$ ProjectID: $5000$ ProjectName: Project $3$ Introduction to Database$$ Department: InfoSystems$$ MaxHours: $20$ StartDate: $2030-05-02$ EndDate: $2032-05-104)$ InsertanewAssignmentrecordintotheASSIGNMENTtablewiththe following info:$$ ProjectID: $5000$ EmployeeNumber: $($your employee number from the record youinserted for yourself$)$ HoursWorked: $20$After you submit your project, your instructor will view your implemented database by logging in to itins$3.$madisoncollege.edu to give you points for Part C$\mathrm{.}4$Introduction to Databases Project $3$Part DWrite out the queries for the following$1)$ Listoutthefirstnameandlastnameforalloftheemployees. a$.$ This one is done for you...SELECT FirstName, LastName FROM EMPLOYEE;$2)$ Listoutthedepartmentnameandofficenumberforallofthedepartments$\mathrm{.}3)$ Listouttheprojectnameandmaxhoursforalloftheprojects$\mathrm{.}4)$ ListoutallofthecolumnsandrowsintheASSIGNMENTtable$\mathrm{.}5)$ JOINtheEMPLOYEEandDEPARTMENTtablesandlistoutthefirstname,last name, department name, and budget code for each employee:a$.$ This one is done for you...SELECT FirstName, LastName, DepartmentName, BudgetCode FROM EMPLOYEE JOIN DEPARTMENT ON DEPARTMENT.DepartmentName $=$ EMPLOYEE.Department;$6)$ JOINtheEMPLOYEEandDEPARTMENTtablesandlistoutthefirstname,last name, department name, and budget code, but only for employees in the InfoSystems department$\mathrm{.}5$Introduction to Databases Project $3$ PART ESetup a PHP file at the root of your web server $($htdocs$)$ using the WAMP virtual machine to query the database you created and display some results in an HTML table$\mathrm{.}1)$ Createanewfilecalledemployees.php$2)$ DisplaytheEmployeeNumber,FirstName,LastName,andEmailforallemployees by querying the EMPLOYEE table$\mathrm{.}3)$ SubmitascreenshotoftheHTMLtableshowingtheemployeeinformation described in Step $2$; be sure to include the URL in the screenshot. This is how you will earn points for Part E$.$HINT: Refer to Assignment $7$C or the practice project video if you are stuck.Heres an example screenshot of the Employee Table displayed on a webpage