Question: ERROR:Foreign key constraint is incorrectly formed for the Dependent SQL Code Heres all the code below: CREATE TABLE EMPLOYEE _ maw ( SSN _ Number
ERROR:"Foreign key constraint is incorrectly formed" for the Dependent SQL Code
Heres all the code below:
CREATE TABLE EMPLOYEEmaw
SSNNumber CHAR NOT NULL,
FirstName VARCHAR NOT NULL,
MidName CHAR,
LastName VARCHAR NOT NULL,
Birthday DATE,
Address VARCHAR
Gender CHAR CHECK Gender IN MFmf
Salary DECIMAL DEFAULT
SupervisorSSN CHAR
DepartmentNumber INT,
CONSTRAINT EMPLOYEEPK PRIMARY KEYSSNNumber
CONSTRAINT EMPLOYEEFK FOREIGN KEYSupervisorSSN REFERENCES EMPLOYEEmawSSNNumber;
CREATE TABLE DEPARTMENTmaw
DepartmentName VARCHAR NOT NULL,
DepartmentNumber INT NOT NULL,
ManagerSSN CHAR NOT NULL,
ManageStartDate DATE,
PRIMARY KEY DepartmentNumber
CONSTRAINT DEPARTMENTFK FOREIGN KEY ManagerSSN REFERENCES EMPLOYEEmaw SSNNumber;
CREATE TABLE DEPTLOCATIONmaw
DepartmentNumber INT,
DepartmentLocation VARCHAR
CONSTRAINT PKDEPTLOCATION PRIMARY KEY DepartmentNumber
CONSTRAINT FKDEPTLOCATIONDEPARTMENT FOREIGN KEY DepartmentNumber REFERENCES DEPARTMENTmaw DepartmentNumber ON DELETE CASCADE;
CREATE TABLE PROJECTmaw
ProjectName VARCHAR UNIQUE NOT NULL,
ProjectNumber INT PRIMARY KEY,
ProjectLocation VARCHAR
DepartmentNumber INT,
CONSTRAINT PROJECTmawFK FOREIGN KEY DepartmentNumber REFERENCES DEPARTMENTmawDepartmentNumber;
CREATE TABLE PROJECTASSIGNMENTmaw
EmployeeSSN CHAR
ProjectNumber INT,
Hours DECIMAL NOT NULL,
CONSTRAINT PROJECTASSIGNMENTmawPK PRIMARY KEY EmployeeSSN ProjectNumber
CONSTRAINT PROJECTASSIGNMENTmawEMPFK FOREIGN KEY EmployeeSSN REFERENCES EMPLOYEEmawSSNNumber ON DELETE CASCADE,
CONSTRAINT PROJECTASSIGNMENTmawPROJFK FOREIGN KEY ProjectNumber REFERENCES PROJECTmawProjectNumber ON DELETE CASCADE;
CREATE TABLE DEPENDENTmaw
EmployeeSSN CHAR NOT NULL,
DependentName VARCHAR NOT NULL,
Sex CHAR NOT NULL CHECK Sex IN MFmf
Birthday DATE,
Relationship VARCHAR
PRIMARY KEY EmployeeSSN DependentName
FOREIGN KEY EmployeeSSN REFERENCES EmployeeSSN ON DELETE CASCADE;
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
