/* put data in student database */

INSERT INTO student (name, studentNumber, class, major)
VALUES ('O''Keefe', 3996194, 1999, 'Math');

INSERT INTO student (name, studentNumber, class, major)
VALUES ('MacLane', 2000001, 1930, 'Math');

INSERT INTO course (courseName, courseNumber, creditHours, department)
VALUES ('Sheaf Theory', 1, 40, 'Math');

INSERT INTO course (courseName, courseNumber, creditHours, department)
VALUES ('Metaphysics', 2, 40, 'Philosophy');

INSERT INTO course (courseName, courseNumber, creditHours, department)
VALUES ('Topology', 3, 60, 'Math');

INSERT INTO prerequisite (courseNumber, prerequisiteNumber)
VALUES (1, 3);

INSERT INTO section (sectionID, courseNumber, semester, year, instructor)
VALUES (1, 1, 'first', 2009, 'Grothendieck');

INSERT INTO section (sectionID, courseNumber, semester, year, instructor)
VALUES (2, 2, 'second', 2009, 'Carnap');

INSERT INTO gradeReport (studentNumber, sectionID, grade)
VALUES (2000001, 1, 'A');

INSERT INTO gradeReport (studentNumber, sectionID, grade)
VALUES (3996194, 1, 'B');

INSERT INTO gradeReport (studentNumber, sectionID, grade)
VALUES (2000001, 2, 'A');

INSERT INTO gradeReport (studentNumber, sectionID, grade)
VALUES (3996194, 2, 'A');