API tools faq
paste
Advertisement
3l1t3Sn1P3r

NASA DataBase Source by DarkSec

3l1t3Sn1P3r
May 5th, 2015
359
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.70 KB | None | 0 0
raw download clone embed print report
  1. #DataBase of #NASA
  2. #DarkSec
  3.  
  4. DROP table NASA_Assigned;
  5. DROP table NASA_SpaceCraft;
  6. DROP table NASA_Mission;
  7. DROP table NASA_Astronaut;
  8. DROP table NASA_Projects;
  9.  
  10. Create table NASA_Projects
  11. (
  12. project char(15),
  13.  
  14. CONSTRAINT NASA_ProjectsPK PRIMARY KEY (project)
  15. );
  16.  
  17. Create table NASA_Astronaut
  18. (
  19. astroNo integer,
  20. astroName char(25),
  21. birth integer,
  22. death integer,
  23.  
  24. CONSTRAINT NASA_AstronautPK PRIMARY KEY (astroNo)
  25. );
  26.  
  27. Create table NASA_Mission
  28. (
  29. projectName char(15),
  30. missionNo integer,
  31. missionType char(2),
  32. launchYear integer,
  33. launchMonth integer,
  34. launchDay integer,
  35. days integer,
  36. hours integer,
  37. minutes integer,
  38. description char(80),
  39.  
  40. CONSTRAINT NASA_MissionPK PRIMARY KEY (projectName, missionNo),
  41. CONSTRAINT NASA_MissionFK FOREIGN KEY (projectName) REFERENCES NASA_Projects
  42. );
  43.  
  44.  
  45. Create table NASA_Assigned
  46. (
  47. projectName char(15),
  48. missionNo integer,
  49. astroNo integer,
  50. role char(25),
  51.  
  52. CONSTRAINT NASA_AssignedPK PRIMARY KEY (projectName, missionNo, astroNo),
  53.  
  54. CONSTRAINT NASA_AssignedFK_Mission FOREIGN KEY
  55. (projectName, missionNo) REFERENCES NASA_Mission,
  56.  
  57. CONSTRAINT NASA_AssignedFK_Astronaut FOREIGN KEY
  58. (astroNo) REFERENCES NASA_Astronaut
  59.  
  60. );
  61.  
  62. Create table NASA_SpaceCraft
  63. (
  64. projectName char(15),
  65. missionNo integer,
  66. craftType char(10),
  67. craftName char(20),
  68.  
  69. CONSTRAINT NASA_SpaceCraftPK PRIMARY KEY (projectName, missionNo, craftType),
  70.  
  71. CONSTRAINT NASA_SpaceCraftFK FOREIGN KEY
  72. (projectName, missionNo) REFERENCES NASA_Mission
  73. );
  74.  
  75. INSERT INTO NASA_Projects VALUES('Mercury');
  76. INSERT INTO NASA_Projects VALUES('Gemini');
  77. INSERT INTO NASA_Projects VALUES('Apollo');
  78. INSERT INTO NASA_Projects VALUES('Skylab');
  79. INSERT INTO NASA_Projects VALUES('Apollo-Soyuz');
  80.  
  81.  
  82.  
  83. Insert into NASA_Astronaut VALUES( 1,'Aldrin, Buzz',1930,NULL);
  84. Insert into NASA_Astronaut VALUES( 2,'Anders, William',1933,NULL);
  85. Insert into NASA_Astronaut VALUES( 3,'Armstrong, Neil',1930,NULL);
  86. Insert into NASA_Astronaut VALUES( 4,'Bean, Alan',1932,NULL);
  87. Insert into NASA_Astronaut VALUES( 5,'Borman, Frank',1928,NULL);
  88. Insert into NASA_Astronaut VALUES( 6,'Brand, Vance',1931,NULL);
  89. Insert into NASA_Astronaut VALUES( 7,'Carpenter, Scott',1925,NULL);
  90. Insert into NASA_Astronaut VALUES( 8,'Carr, Gerald',1932,NULL);
  91. Insert into NASA_Astronaut VALUES( 9,'Cernan, Gene',1934,NULL);
  92. Insert into NASA_Astronaut VALUES(10,'Chaffee, Roger',1935,1967);
  93. Insert into NASA_Astronaut VALUES(11,'Collins, Michael',1930,NULL);
  94. Insert into NASA_Astronaut VALUES(12,'Conrad, Charles',1930,1999);
  95. Insert into NASA_Astronaut VALUES(13,'Cooper, Gordo',1927,2004);
  96. Insert into NASA_Astronaut VALUES(14,'Cunningham, Walter',1932,NULL);
  97. Insert into NASA_Astronaut VALUES(15,'Duke, Charles',1935,NULL);
  98. Insert into NASA_Astronaut VALUES(16,'Eisele, Donn',1930,1987);
  99. Insert into NASA_Astronaut VALUES(17,'Evans, Ron',1933,1990);
  100. Insert into NASA_Astronaut VALUES(18,'Garriott, Owen',1930,NULL);
  101. Insert into NASA_Astronaut VALUES(19,'Gibson, Edward',1936,NULL);
  102. Insert into NASA_Astronaut VALUES(20,'Glenn, John',1921,NULL);
  103. Insert into NASA_Astronaut VALUES(21,'Gordon, Richard',1929,NULL);
  104. Insert into NASA_Astronaut VALUES(22,'Grissom, Gus',1926,1967);
  105. Insert into NASA_Astronaut VALUES(23,'Haise, Fred',1933,NULL);
  106. Insert into NASA_Astronaut VALUES(24,'Irwin, James',1930,1991);
  107. Insert into NASA_Astronaut VALUES(25,'Kerwin, Joseph',1932,NULL);
  108. Insert into NASA_Astronaut VALUES(26,'Lousma, Jack',1936,NULL);
  109. Insert into NASA_Astronaut VALUES(27,'Lovell, James',1928,NULL);
  110. Insert into NASA_Astronaut VALUES(28,'Mattingly, Thomas',1936,NULL);
  111. Insert into NASA_Astronaut VALUES(29,'McDivitt, James',1929,NULL);
  112. Insert into NASA_Astronaut VALUES(30,'Mitchell, Edgar',1930,NULL);
  113. Insert into NASA_Astronaut VALUES(31,'Pogue, William',1930,NULL);
  114. Insert into NASA_Astronaut VALUES(32,'Roosa, Stu',1933,1994);
  115. Insert into NASA_Astronaut VALUES(33,'Schirra, Wally',1923,NULL);
  116. Insert into NASA_Astronaut VALUES(34,'Schmitt, Harrison',1935,NULL);
  117. Insert into NASA_Astronaut VALUES(35,'Schweickart, Rusty',1935,NULL);
  118. Insert into NASA_Astronaut VALUES(36,'Scott, David',1932,NULL);
  119. Insert into NASA_Astronaut VALUES(37,'Shepard, Alan',1923,1998);
  120. Insert into NASA_Astronaut VALUES(38,'Slayton, Deke',1924,1993);
  121. Insert into NASA_Astronaut VALUES(39,'Stafford, Thomas',1930,NULL);
  122. Insert into NASA_Astronaut VALUES(40,'Swigert, John',1931,1982);
  123. Insert into NASA_Astronaut VALUES(41,'Weitz, Paul',1932,NULL);
  124. Insert into NASA_Astronaut VALUES(42,'White, Edward',1930,1967);
  125. Insert into NASA_Astronaut VALUES(43,'Worden, Alfred',1932,NULL);
  126. Insert into NASA_Astronaut VALUES(44,'Young, John',1930,NULL);
  127.  
  128.  
  129. Insert into NASA_Mission Values('Mercury', 1, 'SO', 1961, 5, 5, 0, 0, 15, 'First American into space');
  130. Insert into NASA_Mission Values('Mercury', 2, 'SO', 1961, 7, 21, 0, 0, 15, 'Capsule sank after splashdown');
  131. Insert into NASA_Mission Values('Mercury', 3, 'EO', 1962, 2, 20, 0, 4, 55, 'First American into orbit');
  132. Insert into NASA_Mission Values('Mercury', 4, 'EO', 1962, 5, 24, 0, 4, 56, 'Cronkite: We may have lost an astronaut');
  133. Insert into NASA_Mission Values('Mercury', 5, 'EO', 1962, 10, 3, 0, 9, 13,NULL);
  134. Insert into NASA_Mission Values('Mercury', 6, 'EO', 1963, 5, 15, 1, 10, 20,NULL);
  135. Insert into NASA_Mission Values('Gemini', 3, 'EO', 1965, 3, 23, 0, 4, 53, 'First Ham Sandwich in Space');
  136. Insert into NASA_Mission Values('Gemini', 4, 'EO', 1965, 6, 3, 4, 1, 56, 'First American Spacewalk');
  137. Insert into NASA_Mission Values('Gemini', 5, 'EO', 1965, 8, 21, 7, 22, 55, 'Eight Days or Bust');
  138. Insert into NASA_Mission Values('Gemini', 6, 'EO', 1965, 12, 15, 1, 1, 52, 'First Rendevous');
  139. Insert into NASA_Mission Values('Gemini', 7, 'EO', 1965, 12, 4, 13, 18, 35, 'Longest Flight not on a Space Station');
  140. Insert into NASA_Mission Values('Gemini', 8, 'EO', 1966, 3, 16, 0, 10, 41, 'First docking; first space emergency');
  141. Insert into NASA_Mission Values('Gemini', 9, 'EO', 1966, 6, 3, 3, 0, 20, 'The Angry Alligator; aborted spacewalk');
  142. Insert into NASA_Mission Values('Gemini', 10, 'EO', 1966, 7, 18, 2, 22, 47,NULL);
  143. Insert into NASA_Mission Values('Gemini', 11, 'EO', 1966, 9, 12, 2, 23, 17,NULL);
  144. Insert into NASA_Mission Values('Gemini', 12, 'EO', 1966, 11, 11, 3, 22, 34, 'First unequivocally successful EVA');
  145. Insert into NASA_Mission Values('Apollo', 1, NULL, 1967, 1, 27, 0, 0, 0, 'Crew killed in launch test');
  146. Insert into NASA_Mission Values('Apollo', 7, 'EO', 1968, 10, 11, 10, 20, 9, 'First successful Apollo mission');
  147. Insert into NASA_Mission Values('Apollo', 8, 'LO', 1968, 12, 21, 6, 3, 0, 'THAT photo of Earth from Moon; Genesis');
  148. Insert into NASA_Mission Values('Apollo', 9, 'EO', 1969, 3, 3, 10, 1, 0,'First test of Lunar Module');
  149. Insert into NASA_Mission Values('Apollo', 10, 'LO', 1969, 5, 18, 8, 0, 3,NULL);
  150. Insert into NASA_Mission Values('Apollo', 11, 'LL', 1969, 7, 16, 8, 3, 19, 'One Small Step for [a] man, one giant leap for mankind');
  151. Insert into NASA_Mission Values('Apollo', 12, 'LL', 1969, 11, 14, 10, 4, 36, 'It might have been a small step for Neil, but it was a big one for me');
  152. Insert into NASA_Mission Values('Apollo', 13, 'LF', 1970, 4, 11, 5, 22, 54, 'Houston, we have a problem');
  153. Insert into NASA_Mission Values('Apollo', 14, 'LL', 1971, 1, 31, 9, 0, 0,NULL);
  154. Insert into NASA_Mission Values('Apollo', 15, 'LL', 1971, 7, 26, 12, 7, 12, 'Man must explore; First use of lunar rover');
  155.  
  156. Insert into NASA_Mission Values('Apollo', 16, 'LL', 1972, 4, 16, 11, 1, 51,NULL);
  157. Insert into NASA_Mission Values('Apollo', 17, 'LL', 1972, 12, 7, 12, 13, 51,NULL);
  158. Insert into NASA_Mission Values('Skylab', 2, 'EO', 1973, 5, 25, 28, 0, 50, 'Skylab rescue mission');
  159. Insert into NASA_Mission Values('Skylab', 3, 'EO', 1973, 7, 28, 59, 11, 9,NULL);
  160. Insert into NASA_Mission Values('Skylab', 4, 'EO', 1973, 11, 16, 84, 1, 15,NULL);
  161. Insert into NASA_Mission Values('Apollo-Soyuz', 1, 'EO', 1975, 7, 15, 9, 1, 28,NULL);
  162.  
  163.  
  164. Insert into NASA_SpaceCraft Values('Mercury', 1, 'capsule', 'Freedom 7');
  165. Insert into NASA_SpaceCraft Values('Mercury', 2, 'capsule', 'Liberty Bell 7');
  166. Insert into NASA_SpaceCraft Values('Mercury', 3, 'capsule', 'Friendship 7');
  167. Insert into NASA_SpaceCraft Values('Mercury', 4, 'capsule', 'Aurora 7');
  168. Insert into NASA_SpaceCraft Values('Mercury', 5, 'capsule', 'Sigma 7');
  169. Insert into NASA_SpaceCraft Values('Mercury', 6, 'capsule', 'Faith 7');
  170. Insert into NASA_SpaceCraft Values('Gemini', 3, 'capsule', 'Molly Brown');
  171. Insert into NASA_SpaceCraft Values('Apollo', 9, 'CSM', 'Gum Drop');
  172. Insert into NASA_SpaceCraft Values('Apollo', 9, 'LM', 'Spider');
  173. Insert into NASA_SpaceCraft Values('Apollo', 10, 'CSM', 'Charlie Brown');
  174. Insert into NASA_SpaceCraft Values('Apollo', 10, 'LM', 'Snoopy');
  175. Insert into NASA_SpaceCraft Values('Apollo', 11, 'CSM', 'Columbia');
  176. Insert into NASA_SpaceCraft Values('Apollo', 11, 'LM', 'Eagle');
  177. Insert into NASA_SpaceCraft Values('Apollo', 12, 'CSM', 'Yankee Clipper');
  178. Insert into NASA_SpaceCraft Values('Apollo', 12, 'LM', 'Intrepid');
  179. Insert into NASA_SpaceCraft Values('Apollo', 13, 'CSM', 'Odyssey');
  180. Insert into NASA_SpaceCraft Values('Apollo', 13, 'LM', 'Aquarius');
  181. Insert into NASA_SpaceCraft Values('Apollo', 14, 'CSM', 'Kitty Hawk');
  182. Insert into NASA_SpaceCraft Values('Apollo', 14, 'LM', 'Antares');
  183. Insert into NASA_SpaceCraft Values('Apollo', 15, 'CSM', 'Endeavour');
  184. Insert into NASA_SpaceCraft Values('Apollo', 15, 'LM', 'Falcon');
  185. Insert into NASA_SpaceCraft Values('Apollo', 16, 'CSM', 'Casper');
  186. Insert into NASA_SpaceCraft Values('Apollo', 16, 'LM', 'Orion');
  187. Insert into NASA_SpaceCraft Values('Apollo', 17, 'CSM', 'America');
  188. Insert into NASA_SpaceCraft Values('Apollo', 17, 'LM', 'Challenger');
  189.  
  190.  
  191. Insert into NASA_Assigned Values('Mercury', 1, 37, 'Pilot');
  192. Insert into NASA_Assigned Values('Mercury', 2, 22, 'Pilot');
  193. Insert into NASA_Assigned Values('Mercury', 3, 20, 'Pilot');
  194. Insert into NASA_Assigned Values('Mercury', 4, 7, 'Pilot');
  195. Insert into NASA_Assigned Values('Mercury', 5, 33, 'Pilot');
  196. Insert into NASA_Assigned Values('Mercury', 6, 13, 'Pilot');
  197. Insert into NASA_Assigned Values('Gemini', 3, 22, 'Commander');
  198. Insert into NASA_Assigned Values('Gemini', 3, 44, 'Pilot');
  199. Insert into NASA_Assigned Values('Gemini', 4, 29, 'Commander');
  200. Insert into NASA_Assigned Values('Gemini', 4, 42, 'Pilot');
  201. Insert into NASA_Assigned Values('Gemini', 5, 13, 'Commander');
  202. Insert into NASA_Assigned Values('Gemini', 5, 12, 'Pilot');
  203. Insert into NASA_Assigned Values('Gemini', 6, 5, 'Commander');
  204. Insert into NASA_Assigned Values('Gemini', 6, 27, 'Pilot');
  205. Insert into NASA_Assigned Values('Gemini', 7, 33, 'Commander');
  206. Insert into NASA_Assigned Values('Gemini', 7, 39, 'Pilot');
  207. Insert into NASA_Assigned Values('Gemini', 8, 3, 'Commander');
  208. Insert into NASA_Assigned Values('Gemini', 8, 36, 'Pilot');
  209. Insert into NASA_Assigned Values('Gemini', 9, 39, 'Commander');
  210. Insert into NASA_Assigned Values('Gemini', 9, 9, 'Pilot');
  211. Insert into NASA_Assigned Values('Gemini', 10, 44, 'Commander');
  212. Insert into NASA_Assigned Values('Gemini', 10, 11, 'Pilot');
  213. Insert into NASA_Assigned Values('Gemini', 11, 12, 'Commander');
  214. Insert into NASA_Assigned Values('Gemini', 11, 21, 'Pilot');
  215. Insert into NASA_Assigned Values('Gemini', 12, 27, 'Commander');
  216. Insert into NASA_Assigned Values('Gemini', 12, 1, 'Pilot');
  217. Insert into NASA_Assigned Values('Apollo', 1, 22, 'Commander');
  218. Insert into NASA_Assigned Values('Apollo', 1, 42, 'Command Module Pilot');
  219. Insert into NASA_Assigned Values('Apollo', 1, 10, 'Lunar Module Pilot');
  220. Insert into NASA_Assigned Values('Apollo', 7, 33, 'Commander');
  221. Insert into NASA_Assigned Values('Apollo', 7, 16, 'Command Module Pilot');
  222. Insert into NASA_Assigned Values('Apollo', 7, 14, 'Lunar Module Pilot');
  223. Insert into NASA_Assigned Values('Apollo', 8, 5, 'Commander');
  224. Insert into NASA_Assigned Values('Apollo', 8, 27, 'Command Module Pilot');
  225. Insert into NASA_Assigned Values('Apollo', 8, 2, 'Lunar Module Pilot');
  226. Insert into NASA_Assigned Values('Apollo', 9, 29, 'Commander');
  227. Insert into NASA_Assigned Values('Apollo', 9, 36, 'Command Module Pilot');
  228. Insert into NASA_Assigned Values('Apollo', 9, 35, 'Lunar Module Pilot');
  229. Insert into NASA_Assigned Values('Apollo', 10, 39, 'Commander');
  230. Insert into NASA_Assigned Values('Apollo', 10, 44, 'Command Module Pilot');
  231. Insert into NASA_Assigned Values('Apollo', 10, 9, 'Lunar Module Pilot');
  232. Insert into NASA_Assigned Values('Apollo', 11, 3, 'Commander');
  233. Insert into NASA_Assigned Values('Apollo', 11, 11, 'Command Module Pilot');
  234. Insert into NASA_Assigned Values('Apollo', 11, 1, 'Lunar Module Pilot');
  235. Insert into NASA_Assigned Values('Apollo', 12, 12, 'Commander');
  236. Insert into NASA_Assigned Values('Apollo', 12, 21, 'Command Module Pilot');
  237. Insert into NASA_Assigned Values('Apollo', 12, 4, 'Lunar Module Pilot');
  238. Insert into NASA_Assigned Values('Apollo', 13, 27, 'Commander');
  239. Insert into NASA_Assigned Values('Apollo', 13, 40, 'Command Module Pilot');
  240. Insert into NASA_Assigned Values('Apollo', 13, 23, 'Lunar Module Pilot');
  241. Insert into NASA_Assigned Values('Apollo', 14, 37, 'Commander');
  242. Insert into NASA_Assigned Values('Apollo', 14, 32, 'Command Module Pilot');
  243. Insert into NASA_Assigned Values('Apollo', 14, 30, 'Lunar Module Pilot');
  244.  
  245. Insert into NASA_Assigned Values('Apollo', 15, 43, 'Command Module Pilot');
  246. Insert into NASA_Assigned Values('Apollo', 15, 24, 'Lunar Module Pilot');
  247. Insert into NASA_Assigned Values('Apollo', 16, 44, 'Commander');
  248. Insert into NASA_Assigned Values('Apollo', 16, 28, 'Command Module Pilot');
  249. Insert into NASA_Assigned Values('Apollo', 16, 15, 'Lunar Module Pilot');
  250. Insert into NASA_Assigned Values('Apollo', 17, 9, 'Commander');
  251. Insert into NASA_Assigned Values('Apollo', 17, 17, 'Command Module Pilot');
  252. Insert into NASA_Assigned Values('Apollo', 17, 34, 'Lunar Module Pilot');
  253. Insert into NASA_Assigned Values('Skylab', 2, 12, 'Commander');
  254. Insert into NASA_Assigned Values('Skylab', 2, 41, 'Pilot');
  255. Insert into NASA_Assigned Values('Skylab', 2, 25, 'Scientist');
  256. Insert into NASA_Assigned Values('Skylab', 3, 4, 'Commander');
  257. Insert into NASA_Assigned Values('Skylab', 3, 26, 'Pilot');
  258. Insert into NASA_Assigned Values('Skylab', 3, 18, 'Scientist');
  259. Insert into NASA_Assigned Values('Skylab', 4, 8, 'Commander');
  260. Insert into NASA_Assigned Values('Skylab', 4, 31, 'Pilot');
  261. Insert into NASA_Assigned Values('Skylab', 4, 19, 'Scientist');
  262. Insert into NASA_Assigned Values('Apollo-Soyuz', 1, 39, 'Commander');
  263. Insert into NASA_Assigned Values('Apollo-Soyuz', 1, 6, 'Command Module Pilot');
  264. Insert into NASA_Assigned Values('Apollo-Soyuz', 1, 38, 'Docking Module Pilot');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!