Database Reference
In-Depth Information
TASK 3: INSERTING DATA TO TABLES
After the tables are created, our next step is to insert data to those tables by following the
below steps:
1. In the
ClassDB
pane on the left-hand side of your screen, click the link
[ClassDB].
[Class_Federation]
and select
Query
on the context menu. hen, select
New Query
to open the New Query editor.
2. Enter the following SQL code and click the
Run
button on the ribbon:
--- 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')
