Question: Below is my SQL ode for the DEPARTMENT table in the picture provided, When running the code I get the error forgein key is incorrectly
Below is my SQL ode for the DEPARTMENT table in the picture provided, When running the code I get the error forgein key is incorrectly formed. Could you please show me hw to fix it
CODE FOR DEPARTMENT TABLE:
CREATE TABLE DEPARTMENTmaw
DepartmentName VARCHAR NOT NULL,
DepartmentNumber INT PRIMARY KEY NOT NULL,
ManagerSSN CHAR NOT NULL,
ManageStartDate DATE,
CONSTRAINT DEPARTMENTFK FOREIGN KEYManagerSSN REFERENCES EMPLOYEExxxSSNNumber
;
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
