inal program: Create the following MySQL tables and stuff those tables with the following data:

MySQL table data

Write a PHP$-$based HTML web form that allows an end$-$user to add records to both tables, update records in both tables, and delete records from both tables.

Assignment Submission Instructions

Zip up the following files and submit in one file:

Compiled Module $1-6$ programs with corrections

Lessons learned reflection

Final program course code and application screenshots

The name of the zip file should be LastName$\_$FirstName$\_$MOD$8\_$PORTFOLIO$\_$OPT$2.$zip CREATE TABLE person $($

Id SMALLINT UNSIGNED NOT NULL AUTO$\_$INCREMENT,

name CHAR$(60)$ NOT NULL,

PRIMARY KEY $($id$)$

$)$;

CREATE TABLE shirt $($

Id SMALLINT UNSIGNED NOT NULL AUTO$\_$INCREMENT,

style ENUM$(\text{'}$t$-$shirt', 'polo', 'dress'$)$ NOT NULL,

color ENUM$(\text{'}$red$\text{'},$ 'blue', 'orange', 'white', 'black'$)$ NOT NULL,

owner SMALLINT UNSIGNED NOT NULL REFERENCES person$($id$),$

PRIMARY KEY $($id$)$

$)$;

INSERT INTO person VALUES $($NULL$,$ 'Antonio Paz'$)$;

SELECT @last :$=$ LAST$\_$INSERT$\_$ID $()$;

INSERT INTO shirt VALUES

$($NULL$,$ 'polo', 'blue', @last$),$

$($NULL$,$ 'dress', 'white', @last$),$

$($NULL$,\text{'}$t$-$shirt', 'blue', @last$)$;

INSERT INTO person VALUES $($NULL$,$ 'Lilliana Angelovska'$)$;

SELECT @last :$=$ LAST$\_$INSERT$\_$ID $()$;

INSERT INTO shirt VALUES

$($NULL$,$ 'dress', 'orange', @last$),$

$($NULL$,$ 'polo', 'red', @last$),$

$($NULL$,$ 'dress', 'blue', @last$),$

$($NULL$,\text{'}$t$-$shirt', 'white', @last$)$;