Following code is generating an error message I can not resolve. Please help. The error message is
Fantastic news! We've Found the answer you've been seeking!
Question:
Following code is generating an error message I can not resolve. Please help. The error message is posted above the code.
Error Code: 1215. Cannot add foreign key constraint 0.375 sec
CREATE TABLE QUALIFIED
(FacultyID INT, CourseID VARCHAR(8) ,
DateQualified DATE,
CONSTRAINT QUALIFIED_PK PRIMARY KEY (FacultyID, CourseID),
CONSTRAINT QUALIFIED_FK FOREIGN KEY (FacultyID) REFERENCES FACULTY(FacultyID),
CONSTRAINT QUALIFIED_FK FOREIGN KEY (CourseID) REFERENCES COURSE(CourseID));
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: