Question: ( CREATE TABLE Class ( ClassID INTEGER PRIMARY KEY, Section TEXT, Time TEXT, CourseCode TEXT, ProfessorID INTEGER, RoomID INTEGER, SemesterID INTEGER, FOREIGN KEY ( CourseCode
CREATE TABLE Class
ClassID INTEGER PRIMARY KEY,
Section TEXT,
Time TEXT,
CourseCode TEXT,
ProfessorID INTEGER,
RoomID INTEGER,
SemesterID INTEGER,
FOREIGN KEY
CourseCode
REFERENCES Course CourseCode
FOREIGN KEY
ProfessorID
REFERENCES Professor ProfessorID
FOREIGN KEY
RoomID
REFERENCES Room RoomID
FOREIGN KEY
SemesterID
REFERENCES Semester SemesterID
; for this DDL i am trying to insert INSERT INTO Class ClassID Section, Time, CourseCode, ProfessorID, RoomID, SemesterID VALUES
A::AC
B::MS
A::CS
B::TD
A::SA
B::BN
A::DA
B::SE
A::MN
A::CM
B:: 'Cal
A::OC; this data i am getting error :: Error while executing SQL query on database 'MITMITUni': FOREIGN KEY constraint failed Please help with the error
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
