Final 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.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$)$;