Relational Database Assignment - Payroll

Must be done in PHP

1. Create the tables in the payroll database described in payrolldb.html. Be sure to set up the primary keys. Look at the queries below before you put in the data so you can enter data that works with the queries.
2. Using a select, query the database and show the employee number, employee number, department number and department name.
3. Query the database and show the projects where the hours employee worked on the project are greater than 100. I want to see project number, project name and hours employee worked on the project.
4. Develop a query that uses three tables.
5. Develop a query that uses four tables.
6. Update a record on one of the tables.
7. Drop one of the records on one of the tables