Create the SQL Code to insert the data for each of the tables in the database provided in the pictures. I will provide the SQL code used to create the tables as well in case its needed. You can ignore the Dependent tables data, as that one has not been created yet.

SQL CODE USED TO CREATE THE TABLES:

CREATE TABLE EMPLOYEE$\_$maw

$($SSN$\_$Number CHAR$(9)$ NOT NULL,

First$\_$Name VARCHAR$(15)$ NOT NULL,

Mid$\_$Name CHAR,

Last$\_$Name VARCHAR$(15)$ NOT NULL,

Birthday DATE,

Address VARCHAR$(50),$

Gender CHAR CHECK $($Gender IN $(\text{'}$M$\text{'},\text{'}$F$\text{'},\text{'}$m$\text{'},\text{'}$f$\text{'})),$

Salary DECIMAL DEFAULT $80000,$

Supervisor$\_$SSN CHAR$(9),$

Department$\_$Number INT,

CONSTRAINT EMPLOYEE$\_$PK PRIMARY KEY$($SSN$\_$Number$),$

CONSTRAINT EMPLOYEE$\_$FK FOREIGN KEY$($Supervisor$\_$SSN$)$ REFERENCES EMPLOYEE$\_$maw$($SSN$\_$Number$))$;

CREATE TABLE DEPARTMENT$\_$maw

$($Department$\_$Name VARCHAR$(15)$ NOT NULL,

Department$\_$Number INT NOT NULL,

Manager$\_$SSN CHAR$(9)$ NOT NULL,

ManageStartDate DATE,

PRIMARY KEY $($Department$\_$Number$),$

CONSTRAINT DEPARTMENT$\_$FK FOREIGN KEY $($Manager$\_$SSN$)$ REFERENCES EMPLOYEE$\_$maw $($SSN$\_$Number$))$;

CREATE TABLE DEPT$\_$LOCATION$\_$maw

$($Department$\_$Number INT,

Department$\_$Location VARCHAR$(15),$

CONSTRAINT PK$\_$DEPT$\_$LOCATION PRIMARY KEY $($Department$\_$Number$),$

CONSTRAINT FK$\_$DEPT$\_$LOCATION$\_$DEPARTMENT FOREIGN KEY $($Department$\_$Number$)$ REFERENCES DEPARTMENT$\_$maw $($Department$\_$Number$)$ ON DELETE CASCADE$)$;

CREATE TABLE PROJECT$\_$maw

$($Project$\_$Name VARCHAR$(15)$ UNIQUE NOT NULL,

Project$\_$Number INT PRIMARY KEY,

Project$\_$Location VARCHAR$(15),$

Department$\_$Number INT,

CONSTRAINT PROJECT$\_$maw$\_$FK FOREIGN KEY $($Department$\_$Number$)$ REFERENCES DEPARTMENT$\_$maw$($Department$\_$Number$))$;

CREATE TABLE PROJECT$\_$ASSIGNMENT$\_$maw

$($Employee$\_$SSN CHAR$(9),$

Project$\_$Number INT,

Hours DECIMAL$(3,1)$ NOT NULL,

CONSTRAINT PROJECT$\_$ASSIGNMENT$\_$maw$\_$PK PRIMARY KEY $($Employee$\_$SSN$,$ Project$\_$Number$),$

CONSTRAINT PROJECT$\_$ASSIGNMENT$\_$maw$\_$EMP$\_$FK FOREIGN KEY $($Employee$\_$SSN$)$ REFERENCES EMPLOYEE$\_$maw$($SSN$\_$Number$)$ ON DELETE CASCADE,

CONSTRAINT PROJECT$\_$ASSIGNMENT$\_$maw$\_$PROJ$\_$FK FOREIGN KEY $($Project$\_$Number$)$ REFERENCES PROJECT$\_$maw$($Project$\_$Number$)$ ON DELETE CASCADE$)$;

Table Name: EMPLOYEE$\_$xxx

Table Name: DEPARTMENT$\_$xxx

Table Name: DEPT$\_$LOCATION$\_$xxx

Table Name: PROJECT$\_$xxx