Answered step by step
Verified Expert Solution
Question
1 Approved Answer
( 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started