1. UseAssignment4.sqlfile to create a table in your database on the database server. You may add more records to the table.
2. Design and build a web page PHP that lists all departments unique in a drop down list. Upon selecting a department and clicking a search button, your page should display all fields for all employees belonging to the selected department. Use an HTML table to display your results. Name this file part1.php
3. Design and build a web page PHP that lets the user search by employee last name. Use a text box for input and a search button. All fields for exact and partial matches should be displayed in an HTML table. Name this file part2.php
4. Design and build a web page PHP that contains employee names in a drop down list use the format Last Name, First Name. Upon selecting an employee and clicking a button, your page should display all fields for the selected employee. Name this file part3.php
5. Design and build a web page PHP that lets a user update an employees salary. You can reuse code from the previous part to build a drop down list containing employee names. The user selects an employee, enters their new salary in a text box, and clicks a button to update their salary. Name this file part4.php
6. Design and build a web page PHP that lists all departments unique in a drop down list and all performances unique in another drop down list. The user selects a value from each of the drop down lists and clicks a search button. Upon doing so, your page should display all fields for employees with the selected department and selected performance. Name this file part5. php