Create the SQL coe for the Dependent table shown in the picture. Te rest of the SQL code for the other tables will be provided below

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

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