Database Development and Management with SQL - Cloud Database Development and Management - page 158

INSERT INTO FACULTY_CLASS (FacultyID, ClassID)
VALUES(4, 1001)
INSERT INTO FACULTY_CLASS (FacultyID, ClassID)
VALUES(1, 1003)
INSERT INTO FACULTY_CLASS (FacultyID, ClassID)
VALUES(3, 1004)
INSERT INTO FACULTY_CLASS (FacultyID, ClassID)
VALUES(2, 1006)
INSERT INTO FACULTY_CLASS (FacultyID, ClassID)
VALUES(3, 1005)
— - inserting records into COURSE_PREREQUISITE
INSERT INTO COURSE_PREREQUISITE (CourseId, Prerequisite)
VALUES('ISC3311', 'ISC2301')
INSERT INTO COURSE_PREREQUISITE (CourseId, Prerequisite)
VALUES('ISC3321', 'ISC3311')
INSERT INTO COURSE_PREREQUISITE (CourseId, Prerequisite)
VALUES('ISC4301', 'ISC3311')
INSERT INTO COURSE_PREREQUISITE (CourseId, Prerequisite)
VALUES('ISC4301', 'ISC3321')
— - inserting records into CLASS_CLASSROOM
INSERT INTO CLASS_CLASSROOM (ClassID, ClassroomID, BuildingID)
VALUES(1000, 103, 2)
INSERT INTO CLASS_CLASSROOM (ClassID, ClassroomID, BuildingID)
VALUES(1001, 105, 1)
INSERT INTO CLASS_CLASSROOM (ClassID, ClassroomID, BuildingID)
VALUES(1002, 206, 3)
INSERT INTO CLASS_CLASSROOM (ClassID, ClassroomID, BuildingID)
VALUES(1003, 107, 3)
INSERT INTO CLASS_CLASSROOM (ClassID, ClassroomID, BuildingID)
VALUES(1004, 305, 2)
INSERT INTO CLASS_CLASSROOM (ClassID, ClassroomID, BuildingID)
VALUES(1000, 121, 2)
INSERT INTO CLASS_CLASSROOM (ClassID, ClassroomID, BuildingID)
VALUES(1001, 107, 3)
INSERT INTO CLASS_CLASSROOM (ClassID, ClassroomID, BuildingID)
VALUES(1006, 215, 1)
INSERT INTO CLASS_CLASSROOM (ClassID, ClassroomID, BuildingID)
VALUES(1005, 105, 4)