API tools faq
paste
Shishu

sql data

Shishu
May 24th, 2018
200
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.60 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM prereq;
  2. DELETE FROM time_slot;
  3. DELETE FROM advisor;
  4. DELETE FROM takes;
  5. DELETE FROM student;
  6. DELETE FROM teaches;
  7. DELETE FROM SECTION;
  8. DELETE FROM instructor;
  9. DELETE FROM course;
  10. DELETE FROM department;
  11. DELETE FROM classroom;
  12. INSERT INTO classroom VALUES ('Packard', '101', '500');
  13. INSERT INTO classroom VALUES ('Painter', '514', '10');
  14. INSERT INTO classroom VALUES ('Taylor', '3128', '70');
  15. INSERT INTO classroom VALUES ('Watson', '100', '30');
  16. INSERT INTO classroom VALUES ('Watson', '120', '50');
  17. INSERT INTO department VALUES ('Biology', 'Watson', '90000');
  18. INSERT INTO department VALUES ('Comp. Sci.', 'Taylor', '100000');
  19. INSERT INTO department VALUES ('Elec. Eng.', 'Taylor', '85000');
  20. INSERT INTO department VALUES ('Finance', 'Painter', '120000');
  21. INSERT INTO department VALUES ('History', 'Painter', '50000');
  22. INSERT INTO department VALUES ('Music', 'Packard', '80000');
  23. INSERT INTO department VALUES ('Physics', 'Watson', '70000');
  24. INSERT INTO course VALUES ('BIO-101', 'Intro. to Biology', 'Biology', '4');
  25. INSERT INTO course VALUES ('BIO-301', 'Genetics', 'Biology', '4');
  26. INSERT INTO course VALUES ('BIO-399', 'Computational Biology', 'Biology', '3');
  27. INSERT INTO course VALUES ('CS-101', 'Intro. to Computer Science', 'Comp. Sci.', '4');
  28. INSERT INTO course VALUES ('CS-190', 'Game Design', 'Comp. Sci.', '4');
  29. INSERT INTO course VALUES ('CS-315', 'Robotics', 'Comp. Sci.', '3');
  30. INSERT INTO course VALUES ('CS-319', 'Image Processing', 'Comp. Sci.', '3');
  31. INSERT INTO course VALUES ('CS-347', 'Database System Concepts', 'Comp. Sci.', '3');
  32. INSERT INTO course VALUES ('EE-181', 'Intro. to Digital Systems', 'Elec. Eng.', '3');
  33. INSERT INTO course VALUES ('FIN-201', 'Investment Banking', 'Finance', '3');
  34. INSERT INTO course VALUES ('HIS-351', 'World History', 'History', '3');
  35. INSERT INTO course VALUES ('MU-199', 'Music Video Production', 'Music', '3');
  36. INSERT INTO course VALUES ('PHY-101', 'Physical Principles', 'Physics', '4');
  37. INSERT INTO instructor VALUES ('10101', 'Srinivasan', 'Comp. Sci.', '65000');
  38. INSERT INTO instructor VALUES ('12121', 'Wu', 'Finance', '90000');
  39. INSERT INTO instructor VALUES ('15151', 'Mozart', 'Music', '40000');
  40. INSERT INTO instructor VALUES ('22222', 'Einstein', 'Physics', '95000');
  41. INSERT INTO instructor VALUES ('32343', 'El Said', 'History', '60000');
  42. INSERT INTO instructor VALUES ('33456', 'Gold', 'Physics', '87000');
  43. INSERT INTO instructor VALUES ('45565', 'Katz', 'Comp. Sci.', '75000');
  44. INSERT INTO instructor VALUES ('58583', 'Califieri', 'History', '62000');
  45. INSERT INTO instructor VALUES ('76543', 'Singh', 'Finance', '80000');
  46. INSERT INTO instructor VALUES ('76766', 'Crick', 'Biology', '72000');
  47. INSERT INTO instructor VALUES ('83821', 'Brandt', 'Comp. Sci.', '92000');
  48. INSERT INTO instructor VALUES ('98345', 'Kim', 'Elec. Eng.', '80000');
  49. INSERT INTO SECTION VALUES ('BIO-101', '1', 'Summer', '2009', 'Painter', '514', 'B');
  50. INSERT INTO SECTION VALUES ('BIO-301', '1', 'Summer', '2010', 'Painter', '514', 'A');
  51. INSERT INTO SECTION VALUES ('CS-101', '1', 'Fall', '2009', 'Packard', '101', 'H');
  52. INSERT INTO SECTION VALUES ('CS-101', '1', 'Spring', '2010', 'Packard', '101', 'F');
  53. INSERT INTO SECTION VALUES ('CS-190', '1', 'Spring', '2009', 'Taylor', '3128', 'E');
  54. INSERT INTO SECTION VALUES ('CS-190', '2', 'Spring', '2009', 'Taylor', '3128', 'A');
  55. INSERT INTO SECTION VALUES ('CS-315', '1', 'Spring', '2010', 'Watson', '120', 'D');
  56. INSERT INTO SECTION VALUES ('CS-319', '1', 'Spring', '2010', 'Watson', '100', 'B');
  57. INSERT INTO SECTION VALUES ('CS-319', '2', 'Spring', '2010', 'Taylor', '3128', 'C');
  58. INSERT INTO SECTION VALUES ('CS-347', '1', 'Fall', '2009', 'Taylor', '3128', 'A');
  59. INSERT INTO SECTION VALUES ('EE-181', '1', 'Spring', '2009', 'Taylor', '3128', 'C');
  60. INSERT INTO SECTION VALUES ('FIN-201', '1', 'Spring', '2010', 'Packard', '101', 'B');
  61. INSERT INTO SECTION VALUES ('HIS-351', '1', 'Spring', '2010', 'Painter', '514', 'C');
  62. INSERT INTO SECTION VALUES ('MU-199', '1', 'Spring', '2010', 'Packard', '101', 'D');
  63. INSERT INTO SECTION VALUES ('PHY-101', '1', 'Fall', '2009', 'Watson', '100', 'A');
  64. INSERT INTO teaches VALUES ('10101', 'CS-101', '1', 'Fall', '2009');
  65. INSERT INTO teaches VALUES ('10101', 'CS-315', '1', 'Spring', '2010');
  66. INSERT INTO teaches VALUES ('10101', 'CS-347', '1', 'Fall', '2009');
  67. INSERT INTO teaches VALUES ('12121', 'FIN-201', '1', 'Spring', '2010');
  68. INSERT INTO teaches VALUES ('15151', 'MU-199', '1', 'Spring', '2010');
  69. INSERT INTO teaches VALUES ('22222', 'PHY-101', '1', 'Fall', '2009');
  70. INSERT INTO teaches VALUES ('32343', 'HIS-351', '1', 'Spring', '2010');
  71. INSERT INTO teaches VALUES ('45565', 'CS-101', '1', 'Spring', '2010');
  72. INSERT INTO teaches VALUES ('45565', 'CS-319', '1', 'Spring', '2010');
  73. INSERT INTO teaches VALUES ('76766', 'BIO-101', '1', 'Summer', '2009');
  74. INSERT INTO teaches VALUES ('76766', 'BIO-301', '1', 'Summer', '2010');
  75. INSERT INTO teaches VALUES ('83821', 'CS-190', '1', 'Spring', '2009');
  76. INSERT INTO teaches VALUES ('83821', 'CS-190', '2', 'Spring', '2009');
  77. INSERT INTO teaches VALUES ('83821', 'CS-319', '2', 'Spring', '2010');
  78. INSERT INTO teaches VALUES ('98345', 'EE-181', '1', 'Spring', '2009');
  79. INSERT INTO student VALUES ('00128', 'Zhang', 'Comp. Sci.', '102');
  80. INSERT INTO student VALUES ('12345', 'Shankar', 'Comp. Sci.', '32');
  81. INSERT INTO student VALUES ('19991', 'Brandt', 'History', '80');
  82. INSERT INTO student VALUES ('23121', 'Chavez', 'Finance', '110');
  83. INSERT INTO student VALUES ('44553', 'Peltier', 'Physics', '56');
  84. INSERT INTO student VALUES ('45678', 'Levy', 'Physics', '46');
  85. INSERT INTO student VALUES ('54321', 'Williams', 'Comp. Sci.', '54');
  86. INSERT INTO student VALUES ('55739', 'Sanchez', 'Music', '38');
  87. INSERT INTO student VALUES ('70557', 'Snow', 'Physics', '0');
  88. INSERT INTO student VALUES ('76543', 'Brown', 'Comp. Sci.', '58');
  89. INSERT INTO student VALUES ('76653', 'Aoi', 'Elec. Eng.', '60');
  90. INSERT INTO student VALUES ('98765', 'Bourikas', 'Elec. Eng.', '98');
  91. INSERT INTO student VALUES ('98988', 'Tanaka', 'Biology', '120');
  92. INSERT INTO takes VALUES ('00128', 'CS-101', '1', 'Fall', '2009', 'A');
  93. INSERT INTO takes VALUES ('00128', 'CS-347', '1', 'Fall', '2009', 'A-');
  94. INSERT INTO takes VALUES ('12345', 'CS-101', '1', 'Fall', '2009', 'C');
  95. INSERT INTO takes VALUES ('12345', 'CS-190', '2', 'Spring', '2009', 'A');
  96. INSERT INTO takes VALUES ('12345', 'CS-315', '1', 'Spring', '2010', 'A');
  97. INSERT INTO takes VALUES ('12345', 'CS-347', '1', 'Fall', '2009', 'A');
  98. INSERT INTO takes VALUES ('19991', 'HIS-351', '1', 'Spring', '2010', 'B');
  99. INSERT INTO takes VALUES ('23121', 'FIN-201', '1', 'Spring', '2010', 'C+');
  100. INSERT INTO takes VALUES ('44553', 'PHY-101', '1', 'Fall', '2009', 'B-');
  101. INSERT INTO takes VALUES ('45678', 'CS-101', '1', 'Fall', '2009', 'F');
  102. INSERT INTO takes VALUES ('45678', 'CS-101', '1', 'Spring', '2010', 'B+');
  103. INSERT INTO takes VALUES ('45678', 'CS-319', '1', 'Spring', '2010', 'B');
  104. INSERT INTO takes VALUES ('54321', 'CS-101', '1', 'Fall', '2009', 'A-');
  105. INSERT INTO takes VALUES ('54321', 'CS-190', '2', 'Spring', '2009', 'B+');
  106. INSERT INTO takes VALUES ('55739', 'MU-199', '1', 'Spring', '2010', 'A-');
  107. INSERT INTO takes VALUES ('76543', 'CS-101', '1', 'Fall', '2009', 'A');
  108. INSERT INTO takes VALUES ('76543', 'CS-319', '2', 'Spring', '2010', 'A');
  109. INSERT INTO takes VALUES ('76653', 'EE-181', '1', 'Spring', '2009', 'C');
  110. INSERT INTO takes VALUES ('98765', 'CS-101', '1', 'Fall', '2009', 'C-');
  111. INSERT INTO takes VALUES ('98765', 'CS-315', '1', 'Spring', '2010', 'B');
  112. INSERT INTO takes VALUES ('98988', 'BIO-101', '1', 'Summer', '2009', 'A');
  113. INSERT INTO takes VALUES ('98988', 'BIO-301', '1', 'Summer', '2010', NULL);
  114. INSERT INTO advisor VALUES ('00128', '45565');
  115. INSERT INTO advisor VALUES ('12345', '10101');
  116. INSERT INTO advisor VALUES ('23121', '76543');
  117. INSERT INTO advisor VALUES ('44553', '22222');
  118. INSERT INTO advisor VALUES ('45678', '22222');
  119. INSERT INTO advisor VALUES ('76543', '45565');
  120. INSERT INTO advisor VALUES ('76653', '98345');
  121. INSERT INTO advisor VALUES ('98765', '98345');
  122. INSERT INTO advisor VALUES ('98988', '76766');
  123. INSERT INTO time_slot VALUES ('A', 'M', '8', '0', '8', '50');
  124. INSERT INTO time_slot VALUES ('A', 'W', '8', '0', '8', '50');
  125. INSERT INTO time_slot VALUES ('A', 'F', '8', '0', '8', '50');
  126. INSERT INTO time_slot VALUES ('B', 'M', '9', '0', '9', '50');
  127. INSERT INTO time_slot VALUES ('B', 'W', '9', '0', '9', '50');
  128. INSERT INTO time_slot VALUES ('B', 'F', '9', '0', '9', '50');
  129. INSERT INTO time_slot VALUES ('C', 'M', '11', '0', '11', '50');
  130. INSERT INTO time_slot VALUES ('C', 'W', '11', '0', '11', '50');
  131. INSERT INTO time_slot VALUES ('C', 'F', '11', '0', '11', '50');
  132. INSERT INTO time_slot VALUES ('D', 'M', '13', '0', '13', '50');
  133. INSERT INTO time_slot VALUES ('D', 'W', '13', '0', '13', '50');
  134. INSERT INTO time_slot VALUES ('D', 'F', '13', '0', '13', '50');
  135. INSERT INTO time_slot VALUES ('E', 'T', '10', '30', '11', '45 ');
  136. INSERT INTO time_slot VALUES ('E', 'R', '10', '30', '11', '45 ');
  137. INSERT INTO time_slot VALUES ('F', 'T', '14', '30', '15', '45 ');
  138. INSERT INTO time_slot VALUES ('F', 'R', '14', '30', '15', '45 ');
  139. INSERT INTO time_slot VALUES ('G', 'M', '16', '0', '16', '50');
  140. INSERT INTO time_slot VALUES ('G', 'W', '16', '0', '16', '50');
  141. INSERT INTO time_slot VALUES ('G', 'F', '16', '0', '16', '50');
  142. INSERT INTO time_slot VALUES ('H', 'W', '10', '0', '12', '30');
  143. INSERT INTO prereq VALUES ('BIO-301', 'BIO-101');
  144. INSERT INTO prereq VALUES ('BIO-399', 'BIO-101');
  145. INSERT INTO prereq VALUES ('CS-190', 'CS-101');
  146. INSERT INTO prereq VALUES ('CS-315', 'CS-101');
  147. INSERT INTO prereq VALUES ('CS-319', 'CS-101');
  148. INSERT INTO prereq VALUES ('CS-347', 'CS-101');
  149. INSERT INTO prereq VALUES ('EE-181', 'PHY-101');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!