Database Reference
In-Depth Information
— - inserting records into COURSE
INSERT INTO COURSE (CourseID, CourseName)
VALUES('ISC2301', 'VB')
INSERT INTO COURSE (CourseID, CourseName)
VALUES('ISC3311', 'Database')
INSERT INTO COURSE (CourseID, CourseName)
VALUES('ISC4301', 'E-Commerce')
INSERT INTO COURSE (CourseID, CourseName)
VALUES('ISC3321', 'Info-Systems')
— - inserting records into TIMEBLOCK
INSERT INTO TIMEBLOCK (TimeID, TimeBlock)
VALUES(1, '9am-12pm')
INSERT INTO TIMEBLOCK (TimeID, TimeBlock)
VALUES(2, '1pm-4pm')
INSERT INTO TIMEBLOCK (TimeID, TimeBlock)
VALUES(3, '7pm-10pm')
— - inserting records into SEMESTER
INSERT INTO SEMESTER(SemesterID, Semester)
VALUES(1, 'Fall')
INSERT INTO SEMESTER(SemesterID, Semester)
VALUES(2, 'Spring')
INSERT INTO SEMESTER(SemesterID, Semester)
VALUES(3, 'Summer')
— - inserting records into DAYS
INSERT INTO DAYS(DayID, WeekDay)
VALUES(1, 'Monday')
INSERT INTO DAYS(DayID, WeekDay)
VALUES(2, 'Tuesday')
INSERT INTO DAYS(DayID, WeekDay)
VALUES(3, 'Wednesday')
INSERT INTO DAYS(DayID, WeekDay)
VALUES(4, 'Thursday')
INSERT INTO DAYS(DayID, WeekDay)
VALUES(5, 'Friday')
INSERT INTO DAYS(DayID, WeekDay)
VALUES(6, 'Saturday')
INSERT INTO DAYS(DayID, WeekDay)
VALUES(7, 'Sunday')
— - inserting records into CLASS
