Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started