Question$1.$ Use phpMyAdmin to create a database called $$Recruitment$\_$yourID$$ that contains the JobApplications table defined as follows:

JobApplications

Field name Data type Length Constraint

applicationID INT $4$ Primary key ; Auto$-$Increment

firstName Varchar $50$ Not Null,

lastName Varchar $50$ Not Null

Nationality Varchar $50$ Not Null

dateOfBirth Date Not Null

userEmail Varchar $50$ Foreign key references userEmail in users table

lastDegree Varchar $50$ Not Null

Specialization Varchar $50$ Not Null

positionAppliedFor Varchar $50$ Not Null

Question$2.$ Download the jobApplication.html file which renders the above form, read carefully the HTML code then write the PHP script $$addApplication$.$php$$ that is able to collect application data from the given form then add these details to the JobApplications table. The script should render the message $$Your application has been saved successfully$$ in case the task is executed properly.

Hint: create a folder with your ID then put the following files inside it:

$$ Your database as sql file $($you need to import the database from phpMyAdmin $)$

$$ jobApplication.html

$$ addApplication.php

$$ Compress the file then submit it Moodle