Create the SQL code for each of the tables

Create Tables $-$ NOTE: Replace the $"x"$ with your

initials in lowercase.

Table Name: EMPLOYEE$\_$Xxx

Department Number INT

Table Name: DEPARTMENT$\_$xxx

Attribute Data Type Primary Foreign

Department Name VARCHAR$(15)$

Department Number INT

Manager SSN CHAR$(9)$

Employee $($SSN$)$

Constraint

NOT NULL

NOT NULL

ON DELETE SET

NULL

Manage Start Date DATE

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

Attribute Data Type Primary Foreign

Department Number INT

Department $($DepNo$)$ ON

DELETE CASCADE

Table Name: PROJECT$\_$Xxx

Attribute Data Type Primary Foreign

Constraint

NOT NULL

Project Name

VARCHAR$(15)$ UNIQUE

NOT NULL

Project Number

INT

Constraint

NOT NULL

Project Location VARCHAR$(15)$

NOT NULL

Department Number INT

Department $($DepNo$)$

Table Name: PROJECT$\_$ASSIGNMENT$\_$xxx

Attribute Data Type Primary Foreign Constraint

Employee SSN CHAR$(9),$ Employee $($SSN$)$ ON $,$ NOT NULL

DELETE CASCADE

Project Number INT

Project $($PNumber$)$ ON

NOT NULL

DELETE CASCADE

Hours

DECIMAL $(3,1)$

NOT NULL