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 EMPLOYEExxx
SSN Number CHAR NOT NULL,
First Name VARCHAR NOT NULL,
Mid Name CHAR
Last Name VARCHAR NOT NULL,
Birtday DATE
Address VARCHAR
Gender CHAR
Salary DECIMAL
Supervisor SSN CHAR
Department Number INT
CONSTRAINT EMPLOYEEPK PRIMARY KEYSSN Number;
CONSTRAINT EMPLOYEEFK FOREIGN KEYSSN Number REFERENCES EMPLOYEExxxSSN Number;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
