Answered step by step
Verified Expert Solution
Link Copied!

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 DEPARTMENT_maw
(Department_Name VARCHAR(15) NOT NULL,
Department_Number INT PRIMARY KEY NOT NULL,
Manager_SSN CHAR(9) NOT NULL,
ManageStartDate DATE,
CONSTRAINT DEPARTMENT_FK FOREIGN KEY(Manager_SSN) REFERENCES EMPLOYEE_xxx(SSN_Number)
);
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Administrator Limited Edition

Authors: Martif Way

1st Edition

B0CGG89N8Z

More Books

Students also viewed these Databases questions

Question

2. Develop a program for effectively managing diversity.

Answered: 1 week ago

Question

7. What is coaching? Is there only one type of coaching? Explain.

Answered: 1 week ago