admissions_webapp/demoScript.sql at dev · RyanFisk2/admissions_webapp · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
/*Populate the Seven given courses for Diana Krall*/
INSERT INTO courses_taken(u_id, crn, grade) VALUES (99999999, 141, 'B+');
INSERT INTO courses_taken(u_id, crn, grade) VALUES (99999999, 144, 'A');
INSERT INTO courses_taken(u_id, crn, grade) VALUES (99999999, 165, 'A');
INSERT INTO courses_taken(u_id, crn, grade) VALUES (99999999, 146, 'A-');
INSERT INTO courses_taken(u_id, crn, grade) VALUES (99999999, 167, 'A');
INSERT INTO courses_taken(u_id, crn, grade) VALUES (99999999, 133, 'B');
INSERT INTO courses_taken(u_id, crn, grade) VALUES (99999999, 195, 'C');

INSERT INTO student_transcript(t_id, dept, cno, grade, semesterid, inform1) VALUES (99999999, "CSCI", "6221", "B+", 8, 0);
INSERT INTO student_transcript(t_id, dept, cno, grade, semesterid, inform1) VALUES (99999999, "CSCI", "6232", "A", 8, 0);
INSERT INTO student_transcript(t_id, dept, cno, grade, semesterid, inform1) VALUES (99999999, "CSCI", "6233", "A", 9, 0);
INSERT INTO student_transcript(t_id, dept, cno, grade, semesterid, inform1) VALUES (99999999, "CSCI", "6241", "A-", 8, 0);
INSERT INTO student_transcript(t_id, dept, cno, grade, semesterid, inform1) VALUES (99999999, "CSCI", "6242", "A", 9, 0);
INSERT INTO student_transcript(t_id, dept, cno, grade, semesterid, inform1) VALUES (99999999, "CSCI", "6283", "B", 7, 0);
INSERT INTO student_transcript(t_id, dept, cno, grade, semesterid, inform1) VALUES (99999999, "CSCI", "6286", "C", 10, 0);