Question: Create the SQL code for each of the tables. Below I have attached an attempt of the SQL code for the first table but I

Create the SQL code for each of the tables. Below I have attached an attempt of the SQL code for the first table but I keep getting errors. Could you fix that and provide the revisisd code. Additonally, when writing the code for the other tables write it in a similar format as the one I provided please and thank you.
Code for EMPLOYEEE table:
CREATE TABLE EMPLOYEE_xxx
(SSN Number CHAR(9) NOT NULL,
First Name VARCHAR(15) NOT NULL,
Mid Name CHAR
Last Name VARCHAR(15) NOT NULL,
Birtday DATE
Address VARCHAR(50)
Gender CHAR
Salary DECIMAL
Supervisor SSN CHAR(9)
Department Number INT
CONSTRAINT EMPLOYEE_PK PRIMARY KEY(SSN Number));
CONSTRAINT EMPLOYEE_FK FOREIGN KEY(SSN Number) REFERENCES EMPLOYEE_xxx(SSN Number));
 Create the SQL code for each of the tables. Below I

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!