Windows Azure SQL Database Views, Indexes, and Federations - Cloud Database Development and Management - page 296

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
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201101, 'ISC2301', 4, 1, 1, 1)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201102, 'ISC3311', 4, 2, 1, 2)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201103, 'ISC4301', 3, 3, 2, 1)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201104, 'ISC2301', 4, 1, 2, 2)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201105, 'ISC3311', 4, 2, 3, 2)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201106, 'ISC4301', 3, 3, 3, 1)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201107, 'ISC3321', 3, 1, 4, 1)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201201, 'ISC2301', 4, 1, 1, 1)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201202, 'ISC3311', 4, 2, 1, 2)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201203, 'ISC4301', 3, 3, 2, 1)