Advertisement
saleks28

SUBD2_8sem

Sep 23rd, 2020
778
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO Software VALUES (5555, 'Windows', 'Proprietary', 999.99);
  2. INSERT INTO Software VALUES (3333, 'Ubuntu', 'GNU GPL', 0.0);
  3. INSERT INTO Software VALUES (100, 'Minesweeper', NULL, NULL);
  4. INSERT INTO Software VALUES (20, 'Winamp', 'Proprietary', 0.0);
  5. INSERT INTO Software VALUES (15, 'Debian', 'GNU GPL', 0.0);
  6. INSERT INTO Software VALUES (30, 'Office Word', 'Proprietary', 50.0);
  7. INSERT INTO Software VALUES (1, 'MS-DOS', 'Proprietary', NULL);
  8. INSERT INTO Software VALUES (10, 'Office Excel', 'Proprietary', 50.99);
  9. INSERT INTO Software VALUES (3, 'ALT Linux', 'Freeware', 0.0);
  10. INSERT INTO Software VALUES (110, 'Google Chrome', 'Freeware', 0.0);
  11. INSERT INTO Software VALUES (5, 'VMware ESX', 'Proprietary', 12200.0);
  12. INSERT INTO Software VALUES (120, 'Mozilla Firefox', 'GNU GPL', 0.0);
  13. INSERT INTO Software VALUES (125, 'Wireshark', 'GNU GPL 2+', 0.0);
  14. INSERT INTO Software VALUES (50, 'Skype', 'Freemium', 20.0);
  15. INSERT INTO Software VALUES (75, 'AVG Internet Security', 'Freemium', 200.0);
  16. INSERT INTO Software VALUES (85, 'CMake', 'New BSD License', 0.0);
  17. INSERT INTO Software VALUES (95, 'PyCharm', 'Freemium', 0.0);
  18. INSERT INTO Software VALUES (60, 'Notepad++', 'GNU GPL 2', 0.0);
  19. INSERT INTO Software VALUES (90, 'iTunes', 'Proprietary', 105.0);
  20. INSERT INTO Software VALUES (150, 'Thunderbird', 'GNU GPL 2', 0.0);
  21. INSERT INTO Software VALUES (220, 'Adobe Acrobat Reader', 'Proprietary', 100.0);
  22. INSERT INTO Software VALUES (45, 'WinRAR', 'Trialware', 120.0);
  23. INSERT INTO Software VALUES (190, 'Adobe Photoshop', 'Freemium', 0.0);
  24. INSERT INTO Software VALUES (65, 'Visual Studio', 'Proprietary', 600.0);
  25.  
  26. INSERT INTO Computer_System VALUES (10001, 'CS1', 'Server');
  27. INSERT INTO Computer_System VALUES (10002, 'CS2', 'Server');
  28. INSERT INTO Computer_System VALUES (10003, 'CS3', 'PC');
  29. INSERT INTO Computer_System VALUES (10004, 'CS4', 'PC');
  30. INSERT INTO Computer_System VALUES (10005, 'CS5', 'PC');
  31. INSERT INTO Computer_System VALUES (10006, 'CS6', 'PC');
  32. INSERT INTO Computer_System VALUES (10007, 'CS7', 'Net');
  33. INSERT INTO Computer_System VALUES (10008, 'CS8', 'Net');
  34. INSERT INTO Computer_System VALUES (10009, 'CS9', 'Admin');
  35. INSERT INTO Computer_System VALUES (10010, 'CS10', 'Security');
  36.  
  37. INSERT INTO Software_Computer_System VALUES(5555, 10003);
  38. INSERT INTO Software_Computer_System VALUES(5555, 10004);
  39. INSERT INTO Software_Computer_System VALUES(5555, 10006);
  40. INSERT INTO Software_Computer_System VALUES(5555, 10001);
  41. INSERT INTO Software_Computer_System VALUES(3333, 10005);
  42. INSERT INTO Software_Computer_System VALUES(3333, 10009);
  43. INSERT INTO Software_Computer_System VALUES(100, 10003);
  44. INSERT INTO Software_Computer_System VALUES(100, 10004);
  45. INSERT INTO Software_Computer_System VALUES(100, 10006);
  46. INSERT INTO Software_Computer_System VALUES(20, 10003);
  47. INSERT INTO Software_Computer_System VALUES(20, 10004);
  48. INSERT INTO Software_Computer_System VALUES(15, 10007);
  49. INSERT INTO Software_Computer_System VALUES(15, 10008);
  50. INSERT INTO Software_Computer_System VALUES(30, 10003);
  51. INSERT INTO Software_Computer_System VALUES(30, 10004);
  52. INSERT INTO Software_Computer_System VALUES(30, 10001);
  53. INSERT INTO Software_Computer_System VALUES(10, 10004);
  54. INSERT INTO Software_Computer_System VALUES(10, 10003);
  55. INSERT INTO Software_Computer_System VALUES(10, 10006);
  56. INSERT INTO Software_Computer_System VALUES(3, 10010);
  57. INSERT INTO Software_Computer_System VALUES(110, 10003);
  58. INSERT INTO Software_Computer_System VALUES(110, 10004);
  59. INSERT INTO Software_Computer_System VALUES(110, 10006);
  60. INSERT INTO Software_Computer_System VALUES(5, 10002);
  61. INSERT INTO Software_Computer_System VALUES(120, 10005);
  62. INSERT INTO Software_Computer_System VALUES(120, 10009);
  63. INSERT INTO Software_Computer_System VALUES(120, 10007);
  64. INSERT INTO Software_Computer_System VALUES(120, 10008);
  65. INSERT INTO Software_Computer_System VALUES(125, 10003);
  66. INSERT INTO Software_Computer_System VALUES(125, 10004);
  67. INSERT INTO Software_Computer_System VALUES(125, 10005);
  68. INSERT INTO Software_Computer_System VALUES(125, 10006);
  69. INSERT INTO Software_Computer_System VALUES(125, 10009);
  70. INSERT INTO Software_Computer_System VALUES(125, 10010);
  71. INSERT INTO Software_Computer_System VALUES(50, 10003);
  72. INSERT INTO Software_Computer_System VALUES(50, 10004);
  73. INSERT INTO Software_Computer_System VALUES(50, 10006);
  74. INSERT INTO Software_Computer_System VALUES(75, 10003);
  75. INSERT INTO Software_Computer_System VALUES(75, 10004);
  76. INSERT INTO Software_Computer_System VALUES(75, 10006);
  77. INSERT INTO Software_Computer_System VALUES(75, 10001);
  78. INSERT INTO Software_Computer_System VALUES(85, 10003);
  79. INSERT INTO Software_Computer_System VALUES(85, 10004);
  80. INSERT INTO Software_Computer_System VALUES(85, 10005);
  81. INSERT INTO Software_Computer_System VALUES(85, 10006);
  82. INSERT INTO Software_Computer_System VALUES(85, 10010);
  83. INSERT INTO Software_Computer_System VALUES(95, 10005);
  84. INSERT INTO Software_Computer_System VALUES(60, 10003);
  85. INSERT INTO Software_Computer_System VALUES(60, 10004);
  86. INSERT INTO Software_Computer_System VALUES(60, 10006);
  87. INSERT INTO Software_Computer_System VALUES(60, 10001);
  88. INSERT INTO Software_Computer_System VALUES(90, 10003);
  89. INSERT INTO Software_Computer_System VALUES(90, 10004);
  90. INSERT INTO Software_Computer_System VALUES(90, 10006);
  91. INSERT INTO Software_Computer_System VALUES(150, 10003);
  92. INSERT INTO Software_Computer_System VALUES(150, 10004);
  93. INSERT INTO Software_Computer_System VALUES(150, 10005);
  94. INSERT INTO Software_Computer_System VALUES(150, 10006);
  95. INSERT INTO Software_Computer_System VALUES(150, 10007);
  96. INSERT INTO Software_Computer_System VALUES(150, 10008);
  97. INSERT INTO Software_Computer_System VALUES(150, 10009);
  98. INSERT INTO Software_Computer_System VALUES(150, 10010);
  99. INSERT INTO Software_Computer_System VALUES(220, 10003);
  100. INSERT INTO Software_Computer_System VALUES(220, 10004);
  101. INSERT INTO Software_Computer_System VALUES(220, 10006);
  102. INSERT INTO Software_Computer_System VALUES(45, 10003);
  103. INSERT INTO Software_Computer_System VALUES(45, 10004);
  104. INSERT INTO Software_Computer_System VALUES(45, 10006);
  105. INSERT INTO Software_Computer_System VALUES(65, 10003);
  106. INSERT INTO Software_Computer_System VALUES(65, 10004);
  107. INSERT INTO Software_Computer_System VALUES(65, 10006);
  108.  
  109. INSERT INTO SystemSoft VALUES (5555, HEXTORAW('18FCF74BE90C3EBD8279CA1F1BC5DEAD'));
  110. INSERT INTO SystemSoft VALUES (3333, HEXTORAW('DEADFCF08279C74BE918ADFC3EB1BC51'));
  111. INSERT INTO SystemSoft VALUES (15, HEXTORAW('9CA181F1F7E94D1EADBFC270C8BC53EB'));
  112. INSERT INTO SystemSoft VALUES (1, HEXTORAW('08FC133785A6412CABF5A130201FBEE1'));
  113. INSERT INTO SystemSoft VALUES (3, HEXTORAW('ABF55A64FBC1337EE120181208FCA130'));
  114. INSERT INTO SystemSoft VALUES (5, HEXTORAW('E1201C13ABF537E645AF8FCA13B81200'));
  115. INSERT INTO SystemSoft VALUES (125, NULL);
  116. INSERT INTO SystemSoft VALUES (75, NULL);
  117. INSERT INTO SystemSoft VALUES (85, NULL);
  118. INSERT INTO SystemSoft VALUES (65, NULL);
  119. INSERT INTO SystemSoft VALUES (95, NULL);
  120.  
  121. INSERT INTO Applications VALUES (45, 'Trialware file archiver utility for Windows, developed by Eugene Roshal of win.rar GmbH', 'File archiver');
  122. INSERT INTO Applications VALUES (100, 'Minesweeper is a single-player puzzle video game', 'Game');
  123. INSERT INTO Applications VALUES (20, 'Media player for Windows, macOS and Android, originally developed by Justin Frankel and Dmitry Boldyrev', 'Media player');
  124. INSERT INTO Applications VALUES (30, 'Word processor developed by Microsoft', 'Word processor');
  125. INSERT INTO Applications VALUES (10, 'Spreadsheet developed by Microsoft for Windows, macOS, Android and iOS', 'Spreadsheet');
  126. INSERT INTO Applications VALUES (110, 'Сross-platform web browser developed by Google', 'Web browser');
  127. INSERT INTO Applications VALUES (120, 'Free and open-source web browser developed by the Mozilla Foundation and its subsidiary, Mozilla Corporation', 'Web browser');
  128. INSERT INTO Applications VALUES (50, 'Telecommunications application that specializes in providing video chat and voice calls between computers, smartwatches over the Internet', 'Instant messaging');
  129. INSERT INTO Applications VALUES (60, 'Text and source code editor for use with Microsoft Windows', 'Source code editor');
  130. INSERT INTO Applications VALUES (90, 'media player, media library, Internet radio broadcaster, mobile device management utility, and the client app for iTunes Store, developed by Apple Inc', 'Media player');
  131. INSERT INTO Applications VALUES (150, 'Free and open-source, cross-platform email client, news client, RSS, and chat client developed by the Mozilla Foundation', 'Email client');
  132. INSERT INTO Applications VALUES (220, 'Application software developed by Adobe Inc. to view, create, manipulate, print and manage files in Portable Document Format', 'Desktop publishing');
  133. INSERT INTO Applications VALUES (190, 'Raster graphics editor developed and published by Adobe Inc. for Windows and macOS', 'Raster graphics editor');
  134.  
  135. INSERT INTO Applications_SystemSoft VALUES (45, 5555);
  136. INSERT INTO Applications_SystemSoft VALUES (100, 5555);
  137. INSERT INTO Applications_SystemSoft VALUES (30, 5555);
  138. INSERT INTO Applications_SystemSoft VALUES (10, 5555);
  139. INSERT INTO Applications_SystemSoft VALUES (110, 5555);
  140. INSERT INTO Applications_SystemSoft VALUES (50, 5555);
  141. INSERT INTO Applications_SystemSoft VALUES (90, 5555);
  142. INSERT INTO Applications_SystemSoft VALUES (60, 5555);
  143. INSERT INTO Applications_SystemSoft VALUES (150, 5555);
  144. INSERT INTO Applications_SystemSoft VALUES (220, 5555);
  145. INSERT INTO Applications_SystemSoft VALUES (120, 5555);
  146. INSERT INTO Applications_SystemSoft VALUES (120, 3333);
  147. INSERT INTO Applications_SystemSoft VALUES (150, 3333);
  148. INSERT INTO Applications_SystemSoft VALUES (120, 15);
  149. INSERT INTO Applications_SystemSoft VALUES (150, 15);
  150. -- Для 3 запроса
  151. INSERT INTO Applications_SystemSoft VALUES (120, 1);
  152. INSERT INTO Applications_SystemSoft VALUES (150, 1);
  153. INSERT INTO Applications_SystemSoft VALUES (120, 3);
  154. INSERT INTO Applications_SystemSoft VALUES (150, 3);
  155. INSERT INTO Applications_SystemSoft VALUES (120, 5);
  156. INSERT INTO Applications_SystemSoft VALUES (150, 5);
  157. INSERT INTO Applications_SystemSoft VALUES (120, 125);
  158. INSERT INTO Applications_SystemSoft VALUES (150, 125);
  159. INSERT INTO Applications_SystemSoft VALUES (120, 75);
  160. INSERT INTO Applications_SystemSoft VALUES (150, 75);
  161. INSERT INTO Applications_SystemSoft VALUES (120, 85);
  162. INSERT INTO Applications_SystemSoft VALUES (150, 85);
  163. INSERT INTO Applications_SystemSoft VALUES (120, 65);
  164. INSERT INTO Applications_SystemSoft VALUES (150, 65);
  165. INSERT INTO Applications_SystemSoft VALUES (120, 95);
  166. INSERT INTO Applications_SystemSoft VALUES (150, 95);
  167.  
  168. INSERT INTO CS_Component VALUES (8, 10007, 'Pink', 1, NULL);
  169. INSERT INTO CS_Component VALUES (9, 10007, 'Yellow', 2, NULL);
  170. INSERT INTO CS_Component VALUES (10, 10010, 'White', 4, NULL);
  171. INSERT INTO CS_Component VALUES (11, 10010, 'Black', 4, NULL);
  172. INSERT INTO CS_Component VALUES (12, 10010, 'Blue', 5, NULL);
  173. INSERT INTO CS_Component VALUES (1, 10001, 'Red', 6, 8);
  174. INSERT INTO CS_Component VALUES (2, 10001, 'Red', NULL, 8);
  175. INSERT INTO CS_Component VALUES (3, 10002, 'Yellow', 8, 8);
  176. INSERT INTO CS_Component VALUES (4, 10002, 'Brown', 9, 8);
  177. INSERT INTO CS_Component VALUES (5, 10003, 'Ground', 4, 11);
  178. INSERT INTO CS_Component VALUES (6, 10004, 'White', 11, 11);
  179. INSERT INTO CS_Component VALUES (7, 10005, 'Green', 12, 11);
  180.  
  181.  
  182.  
Advertisement
RAW Paste Data Copied
Advertisement