
DROP TABLE IF EXISTS schedule;
CREATE TABLE schedule (year VARCHAR(4), term VARCHAR(10), student_id VARCHAR(20), course_id VARCHAR(20));

INSERT INTO schedule VALUES ('2020','SPRING','1010','5010');
INSERT INTO schedule VALUES ('2020','SPRING','1020','5010');
INSERT INTO schedule VALUES ('2020','SUMMER','1020','5020');
INSERT INTO schedule VALUES ('2020','SUMMER','1020','5030');
INSERT INTO schedule VALUES ('2020','FALL',  '1030','5040');
INSERT INTO schedule VALUES ('2020','FALL',  '1030','5050');
INSERT INTO schedule VALUES ('2020','FALL',  '1040','6000');
INSERT INTO schedule VALUES ('2020','FALL',  '1040','7000');
INSERT INTO schedule VALUES ('2020','FALL',  '1050','6000');
INSERT INTO schedule VALUES ('2020','FALL',  '1050','7000');
INSERT INTO schedule VALUES ('2020','FALL',  '1060','6000');
INSERT INTO schedule VALUES ('2020','FALL',  '1060','7000');
