Create the rest of the SQL code for the tables remaining in the picture provided. I have the code already for the first three tables and will provide it below. Create the code in a similar format please and thank you

SQL CODE:

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