Question: I ( CREATE TABLE Enrollment ( EnrollmentID INTEGER PRIMARY KEY, StudentID INTEGER, ClassID INTEGER, EnrollmentDate TEXT, Grade TEXT, FOREIGN KEY ( StudentID ) REFERENCES Student
ICREATE TABLE Enrollment
EnrollmentID INTEGER PRIMARY KEY,
StudentID INTEGER,
ClassID INTEGER,
EnrollmentDate TEXT,
Grade TEXT,
FOREIGN KEY
StudentID
REFERENCES Student StudentID
FOREIGN KEY
ClassID
REFERENCES Class ClassID
; for this constraint INSERT INTO Enrollment EnrollmentID StudentID, ClassID, EnrollmentDate, Grade VALUES
; i am getting :: Error while executing SQL query on database 'MITMITUni': FOREIGN KEY constraint failed this error please help me
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
