INSERT INTO student VALUES
('Smith', 17, 1, 'CS'),
('Brown',  8, 2, 'CS');

INSERT INTO course VALUES
('Intro to Computer Science', 'CS1310', 4,   'CS'),
('Data Structures',           'CS3320', 4,   'CS'),
('Discrete Mathematics',    'MATH2410', 3, 'MATH'),
('Database',                  'CS3380', 3,   'CS');

INSERT INTO section VALUES
( 85, 'MATH2410',   'Fall', 2007,     'King'),
( 92,   'CS1310',   'Fall', 2007, 'Anderson'),
(102,   'CS3320', 'Spring', 2008,    'Knuth'),
(112, 'MATH2410',   'Fall', 2008,    'Chang'),
(119,   'CS1310',   'Fall', 2008, 'Anderson'),
(135,   'CS3380',   'Fall', 2008,    'Stone');

INSERT INTO grade_report VALUES
(17, 112, 'B'),
(17, 119, 'C'),
( 8,  85, 'A'),
( 8,  92, 'A'),
( 8, 102, 'B'),
( 8, 135, 'A');

INSERT INTO prerequisite VALUES
('CS3380',   'CS3320'),
('CS3380', 'MATH2410'),
('CS3320',   'CS1310');
