-
Notifications
You must be signed in to change notification settings - Fork 0
/
add.sql
58 lines (52 loc) · 3.32 KB
/
add.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
insert into students values ('B001', 'Anne', 'Broder', 'junior', 3.17, '[email protected]');
insert into students values ('B002', 'Terry', 'Buttler', 'senior', 3.0, '[email protected]');
insert into students values ('B003', 'Tracy', 'Wang', 'senior', 4.0, '[email protected]');
insert into students values ('B004', 'Barbara', 'Callan', 'junior', 2.5, '[email protected]');
insert into students values ('B005', 'Jack', 'Smith', 'graduate', 3.0, '[email protected]');
insert into students values ('B006', 'Terry', 'Zillman', 'graduate', 4.0, '[email protected]');
insert into students values ('B007', 'Becky', 'Lee', 'senior', 4.0, '[email protected]');
insert into students values ('B008', 'Tom', 'Baker', 'freshman', null, '[email protected]');
insert into courses values ('CS', 432, 'database systems');
insert into courses values ('Math', 314, 'discrete math');
insert into courses values ('CS', 240, 'data structure');
insert into courses values ('Math', 221, 'calculus I');
insert into courses values ('Math', 421, 'calculus II');
insert into courses values ('CS', 532, 'database systems');
insert into courses values ('CS', 552, 'operating systems');
insert into courses values ('BIOL', 425, 'molecular biology');
insert into courses values ('CS', 575, 'Algorithms');
insert into courses values ('CS', 375, 'Algorithms');
insert into courses values ('CS', 140, 'Computer Fundaments');
insert into prerequisites values ('Math', 314, 'Math', 221);
insert into prerequisites values ('Math', 421, 'Math', 221);
insert into prerequisites values ('CS', 532, 'CS', 240);
insert into prerequisites values ('CS', 432, 'CS', 240);
insert into prerequisites values ('CS', 552, 'CS', 240);
insert into prerequisites values ('CS', 375, 'CS', 240);
insert into prerequisites values ('CS', 575, 'CS', 375);
insert into prerequisites values ('CS', 240, 'CS', 140);
insert into prerequisites values ('CS', 575, 'Math', 314);
insert into classes values ('c0001', 'CS', 432, 1, 2014, 'Spring', 5, 0);
insert into classes values ('c0002', 'Math', 314, 1, 2013, 'Fall', 5, 0);
insert into classes values ('c0003', 'Math', 314, 2, 2013, 'Fall', 5, 0);
insert into classes values ('c0004', 'CS', 432, 1, 2013, 'Spring', 5, 0);
insert into classes values ('c0005', 'CS', 240, 1, 2014, 'Spring', 5, 0);
insert into classes values ('c0006', 'CS', 532, 1, 2014, 'Spring', 5, 0);
insert into classes values ('c0007', 'Math', 221, 1, 2014, 'Spring', 5, 0);
insert into classes values ('c0008', 'CS', 375, 1, 2014, 'Fall', 5, 0);
insert into classes values ('c0009', 'CS', 140, 1, 2014, 'Fall', 5, 0);
insert into enrollments values ('B001', 'c0001', 'A');
insert into enrollments values ('B002', 'c0002', 'B');
insert into enrollments values ('B003', 'c0004', 'A');
insert into enrollments values ('B004', 'c0004', 'C');
insert into enrollments values ('B004', 'c0005', 'B');
insert into enrollments values ('B005', 'c0006', 'B');
insert into enrollments values ('B006', 'c0006', 'A');
insert into enrollments values ('B001', 'c0002', 'C');
insert into enrollments values ('B003', 'c0005', null);
insert into enrollments values ('B007', 'c0007', 'A');
insert into enrollments values ('B001', 'c0003', 'B');
insert into enrollments values ('B001', 'c0006', 'B');
insert into enrollments values ('B001', 'c0004', 'A');
insert into enrollments values ('B001', 'c0005', 'B');
insert into enrollments values ('B002', 'c0005', 'B');