Objective: The objective of this assignment is to get you to practice running SQL queries and normalizing databases.

Part 1: SQL

In order to complete the following portion you must first download courseTable.csv and professorTable.csv and import them to your environment (PHPMyAdmin).:

1- Construct an SQL query that will show the assignedID, professorName, and the professors home department for each professor that teaches a 2000 level course (all course codes that begin with a two).

2- Construct an SQL query that will show all the course IDs, lectureTimes, and Lecture durations for the Engineering department.

3- Business Development 3332 is no longer being taught by George (assignedID = 77), it is being taught by Royall (assignedID = 88). Update the course table to reflect this change.

4- In this imaginary university, they have a rule that states any professor cannot lecture for more than 6 hours per week. Construct an SQL query that will find any professor that is lecturing for more than 6 hours per week (please note the result set may be empty).

5- Bonus: write a PHP or Python DB-API script with an HTML5 frontend that will add a professor to the professors table.

Part 2: Database Normalization 1- Normalize the following DB schema up until 3rd normal form:

Employee(eid, first name, middle name, last name, date_of_birth, home_address, national_insurance_number, first_day_of_employment). Remember you need to show your steps starting with 1NF, 2NF, until 3NF.

courseTable course instructorlD department lectureTime lectureLength 16:02 18:10 12:50 3155 5 Engineering 72 Services 85 Product Management 61 Research and Development 18:32 18 Training 33 Legal 1108 1421 2151 2 Marketing 86 Engineering 50 Training 42Human Resources 40 Training 70 Research and Development 14:39 16 Services 70 Product Managcmont 85 Accounting 13:22 12:00 9:02 10:41 12:04 10:37 9:32 3947 3441 3625 1729 1033 3437 1921 1236 1929 850 3194 2703 1516 2369 3971 3 17:22 9:57 11:46 15:22 13:59 18:03 11:34 10:36 9:10 14:35 11:53 10:39 16:53 17:09 11:32 9:22 15:33 9:01 12:57 4 Trainind 25 Accounting 41 Accounting 21 Hurian Resources 20 Accounting 51 Marketing 93 Business Development 65 Product Management 44 Product Management 1058 3763 1125 1144 1902 2293 8 Support 88 Sales 61 Training 16 Support 10 Support 16 Hurman Resources 75 Product Management 73 Research and Development 16:11 3 1983