Listing 1: Code to Create and Populate Courses, 
Materials, and CourseMaterials Tables

CREATE TABLE Courses
(
   courseid   INT         NOT NULL PRIMARY KEY,
   coursename VARCHAR(20) NOT NULL,
   /* other columns */
)

CREATE TABLE Materials
(
   materialid   INT         NOT NULL PRIMARY KEY,
   materialname VARCHAR(20) NOT NULL,
   /* other columns */
)

CREATE TABLE CourseMaterials
(
   courseid   INT NOT NULL REFERENCES Courses,
   materialid INT NOT NULL REFERENCES Materials,
   PRIMARY KEY(courseid, materialid)
)

SET NOCOUNT ON
INSERT INTO Courses VALUES(1, 'course1')
INSERT INTO Courses VALUES(2, 'course2')
INSERT INTO Courses VALUES(3, 'course3')
INSERT INTO Courses VALUES(4, 'course4')
INSERT INTO Courses VALUES(5, 'course5')

INSERT INTO Materials VALUES(1, 'material1')
INSERT INTO Materials VALUES(2, 'material2')
INSERT INTO Materials VALUES(3, 'material3')
INSERT INTO Materials VALUES(4, 'material4')
INSERT INTO Materials VALUES(5, 'material5')
INSERT INTO Materials VALUES(6, 'material6')
INSERT INTO Materials VALUES(7, 'material7')
INSERT INTO Materials VALUES(8, 'material8')

INSERT INTO CourseMaterials VALUES(1, 3)
INSERT INTO CourseMaterials VALUES(1, 4)
INSERT INTO CourseMaterials VALUES(2, 1)
INSERT INTO CourseMaterials VALUES(2, 5)
INSERT INTO CourseMaterials VALUES(2, 6)
INSERT INTO CourseMaterials VALUES(3, 1)
INSERT INTO CourseMaterials VALUES(3, 5)
INSERT INTO CourseMaterials VALUES(3, 6)
INSERT INTO CourseMaterials VALUES(4, 5)
INSERT INTO CourseMaterials VALUES(4, 6)
INSERT INTO CourseMaterials VALUES(5, 7)
INSERT INTO CourseMaterials VALUES(5, 5)
INSERT INTO CourseMaterials VALUES(5, 4)
INSERT INTO CourseMaterials VALUES(5, 3)
INSERT INTO CourseMaterials VALUES(5, 8)