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));