API tools faq
paste
CosminVarlan

Script Creare SQL

CosminVarlan
Jun 5th, 2019
130
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 7.85 KB | None | 0 0
raw download clone embed print report
  1. DROP TABLE studenti
  2. /
  3. DROP TABLE cursuri
  4. /
  5. DROP TABLE note
  6. /
  7. DROP TABLE profesori
  8. /
  9.  
  10. DROP TABLE didactic
  11. /
  12.  
  13. CREATE TABLE studenti(
  14.   nr_matricol CHAR(4) NOT NULL,
  15.   nume VARCHAR2(10),
  16.   prenume VARCHAR2(10),
  17.   an NUMBER(1),
  18.   grupa CHAR(2),
  19.   bursa NUMBER(6,2),
  20.   data_nastere DATE
  21.   )
  22. /
  23.  
  24.  
  25. CREATE TABLE cursuri(
  26.   id_curs CHAR(2) NOT NULL,
  27.   titlu_curs VARCHAR2(15),
  28.   an NUMBER(1),
  29.   semestru NUMBER(1),
  30.   credite NUMBER(2)
  31.   )
  32. /
  33.  
  34. CREATE TABLE note(
  35.   nr_matricol CHAR(4),
  36.   id_curs CHAR(2),
  37.   valoare NUMBER(2),
  38.   data_notare DATE
  39.   )
  40. /
  41.  
  42. CREATE TABLE profesori(
  43.   id_prof CHAR(4),
  44.   nume CHAR(10),
  45.   prenume CHAR(10),
  46.   grad_didactic VARCHAR2(5)
  47.   )
  48. /
  49.  
  50. CREATE TABLE didactic(
  51.   id_prof CHAR(4),
  52.   id_curs CHAR(4)
  53.   )
  54. /
  55.  
  56. --ACCEPT  dmy  PROMPT "Press [Enter] to continue ...";
  57.  
  58. --anul 3 de studiu
  59. INSERT INTO studenti VALUES ('111', 'Popescu', 'Bogdan',3, 'A2',NULL, TO_DATE('17/02/1995', 'dd/mm/yyyy'));
  60. INSERT INTO studenti VALUES ('112', 'Prelipcean', 'Radu',3, 'A2',NULL, TO_DATE('26/05/1995', 'dd/mm/yyyy'));
  61. INSERT INTO studenti VALUES ('113', 'Antonie', 'Ioana',3, 'A2',450, TO_DATE('3/01/1995', 'dd/mm/yyyy'));
  62. INSERT INTO studenti VALUES ('114', 'Arhire', 'Raluca',3, 'A4',NULL, TO_DATE('26/12/1995', 'dd/mm/yyyy'));
  63. INSERT INTO studenti VALUES ('115', 'Panaite', 'Alexandru',3, 'B3',NULL, TO_DATE('13/04/1995', 'dd/mm/yyyy'));
  64.  
  65. -- anul 2 de studiu
  66. INSERT INTO studenti VALUES ('116', 'Bodnar', 'Ioana',2, 'A1',NULL, TO_DATE('26/08/1996', 'dd/mm/yyyy'));
  67. INSERT INTO studenti VALUES ('117', 'Archip', 'Andrada',2, 'A1',350, TO_DATE('03/04/1996', 'dd/mm/yyyy'));
  68. INSERT INTO studenti VALUES ('118', 'Ciobotariu', 'Ciprian',2, 'A1',350, TO_DATE('03/04/1996', 'dd/mm/yyyy'));
  69. INSERT INTO studenti VALUES ('119', 'Bodnar', 'Ioana',2, 'B2',NULL, TO_DATE('10/06/1996', 'dd/mm/yyyy'));
  70.  
  71. -- anul 1 de studiu
  72. INSERT INTO studenti VALUES ('120', 'Pintescu', 'Andrei',1, 'B1',250, TO_DATE('26/08/1997', 'dd/mm/yyyy'));
  73. INSERT INTO studenti VALUES ('121', 'Arhire', 'Alexandra',1, 'B1',NULL, TO_DATE('02/07/1997', 'dd/mm/yyyy'));
  74. INSERT INTO studenti VALUES ('122', 'Cobzaru', 'George',1, 'B1',350, TO_DATE('29/04/1997', 'dd/mm/yyyy'));
  75. INSERT INTO studenti VALUES ('123', 'Bucur', 'Andreea',1, 'B2',NULL, TO_DATE('10/05/1997', 'dd/mm/yyyy'));
  76.  
  77. -- populare tabela cursuri - cate 3 pt fiecare an
  78. INSERT INTO cursuri VALUES ('21', 'Logica', 1, 1, 5);
  79. INSERT INTO cursuri VALUES ('22', 'Matematica', 1, 1, 4);
  80. INSERT INTO cursuri VALUES ('23', 'OOP', 1, 2, 5);
  81. INSERT INTO cursuri VALUES ('24', 'BD', 2, 1, 8);
  82. INSERT INTO cursuri VALUES ('25', 'Java', 2, 2, 5);
  83. INSERT INTO cursuri VALUES ('26', 'Tehnologii Web', 2, 2, 5);
  84. INSERT INTO cursuri VALUES ('27', 'Sec. Info.', 3, 1, 5);
  85. INSERT INTO cursuri VALUES ('28', 'DSFUM', 3, 1, 6);
  86. INSERT INTO cursuri VALUES ('29', 'Limbaje formale', 2, 1, 5);
  87. -- inca una din anu 3 :D
  88.  
  89.  
  90. -- populare tabela profesori
  91. INSERT INTO profesori VALUES ('p1', 'Masalagiu', 'Cristian', 'Prof');
  92. INSERT INTO profesori VALUES ('p2', 'Buraga', 'Sabin', 'Conf');
  93. INSERT INTO profesori VALUES ('p3', 'Lucanu', 'Dorel', 'Prof');
  94. INSERT INTO profesori VALUES ('p4', 'Tiplea', 'Laurentiu', 'Prof');
  95. INSERT INTO profesori VALUES ('p5', 'Iacob', 'Florin', 'Lect');
  96. INSERT INTO profesori VALUES ('p6', 'Breaban', 'Mihaela', 'Conf');
  97. INSERT INTO profesori VALUES ('p7', 'Varlan', 'Cosmin', 'Lect');
  98. INSERT INTO profesori VALUES ('p8', 'Frasinaru', 'Cristian', 'Prof');
  99. INSERT INTO profesori VALUES ('p9', 'Ciobaca', 'Stefan', 'Conf');
  100. INSERT INTO profesori VALUES ('p10', 'Captarencu', 'Oana', 'Lect');
  101. INSERT INTO profesori VALUES ('p11', 'Moruz', 'Alexandru', 'Lect');
  102.  
  103.  
  104. -- populare tabela didactic
  105. INSERT INTO didactic VALUES ('p1','21');
  106. INSERT INTO didactic VALUES ('p9','21');
  107. INSERT INTO didactic VALUES ('p5','22');
  108. INSERT INTO didactic VALUES ('p3','23');
  109. INSERT INTO didactic VALUES ('p6','24');
  110. INSERT INTO didactic VALUES ('p7','24');
  111. INSERT INTO didactic VALUES ('p8','25');
  112. INSERT INTO didactic VALUES ('p2','26');
  113. INSERT INTO didactic VALUES ('p4','27');
  114. INSERT INTO didactic VALUES ('p7','28');
  115.  
  116.  
  117. -- populare tabel note - studentii din anul 3 au toate examenele date, cei din anul 2 doar pe cele din anul 1, cei din 1 - nimic
  118. INSERT INTO note VALUES ('111', '21',  8, TO_DATE('17/02/2014', 'dd/mm/yyyy'));
  119. INSERT INTO note VALUES ('111', '22',  9, TO_DATE('19/02/2014', 'dd/mm/yyyy'));
  120. INSERT INTO note VALUES ('111', '23', 10, TO_DATE('24/06/2014', 'dd/mm/yyyy'));
  121. INSERT INTO note VALUES ('111', '24',  9, TO_DATE('17/02/2015', 'dd/mm/yyyy'));
  122. INSERT INTO note VALUES ('111', '25',  7, TO_DATE('20/06/2015', 'dd/mm/yyyy'));
  123. INSERT INTO note VALUES ('111', '26',  8, TO_DATE('21/06/2015', 'dd/mm/yyyy'));
  124.  
  125. INSERT INTO note VALUES ('112', '21',  7, TO_DATE('25/02/2014', 'dd/mm/yyyy'));
  126. INSERT INTO note VALUES ('112', '22',  6, TO_DATE('19/02/2014', 'dd/mm/yyyy'));
  127. INSERT INTO note VALUES ('112', '23',  5, TO_DATE('24/06/2014', 'dd/mm/yyyy'));
  128. INSERT INTO note VALUES ('112', '24',  6, TO_DATE('17/02/2015', 'dd/mm/yyyy'));
  129. INSERT INTO note VALUES ('112', '25',  7, TO_DATE('20/06/2015', 'dd/mm/yyyy'));
  130. INSERT INTO note VALUES ('112', '26',  4, TO_DATE('21/06/2015', 'dd/mm/yyyy'));
  131.  
  132. INSERT INTO note VALUES ('113', '21',  9, TO_DATE('17/02/2014', 'dd/mm/yyyy'));
  133. INSERT INTO note VALUES ('113', '22',  9, TO_DATE('19/02/2014', 'dd/mm/yyyy'));
  134. INSERT INTO note VALUES ('113', '23',  7, TO_DATE('24/06/2014', 'dd/mm/yyyy'));
  135. INSERT INTO note VALUES ('113', '24', 10, TO_DATE('17/02/2015', 'dd/mm/yyyy'));
  136. INSERT INTO note VALUES ('113', '25',  4, TO_DATE('20/06/2015', 'dd/mm/yyyy'));
  137. INSERT INTO note VALUES ('113', '26',  7, TO_DATE('21/06/2015', 'dd/mm/yyyy'));
  138.  
  139. INSERT INTO note VALUES ('114', '21',  6, TO_DATE('17/02/2014', 'dd/mm/yyyy'));
  140. INSERT INTO note VALUES ('114', '22',  9, TO_DATE('19/02/2014', 'dd/mm/yyyy'));
  141. INSERT INTO note VALUES ('114', '23', 10, TO_DATE('24/06/2014', 'dd/mm/yyyy'));
  142. INSERT INTO note VALUES ('114', '24',  4, TO_DATE('17/02/2015', 'dd/mm/yyyy'));
  143. INSERT INTO note VALUES ('114', '25',  5, TO_DATE('20/06/2015', 'dd/mm/yyyy'));
  144. INSERT INTO note VALUES ('114', '26',  4, TO_DATE('21/06/2015', 'dd/mm/yyyy'));
  145.  
  146. INSERT INTO note VALUES ('115', '21', 10, TO_DATE('17/02/2014', 'dd/mm/yyyy'));
  147. INSERT INTO note VALUES ('115', '22',  7, TO_DATE('19/02/2014', 'dd/mm/yyyy'));
  148. INSERT INTO note VALUES ('115', '23', 10, TO_DATE('24/06/2014', 'dd/mm/yyyy'));
  149. INSERT INTO note VALUES ('115', '24', 10, TO_DATE('17/02/2015', 'dd/mm/yyyy'));
  150. INSERT INTO note VALUES ('115', '25',  8, TO_DATE('20/06/2015', 'dd/mm/yyyy'));
  151. INSERT INTO note VALUES ('115', '26',  9, TO_DATE('21/06/2015', 'dd/mm/yyyy'));
  152.  
  153.  
  154. INSERT INTO note VALUES ('116', '21', 10, TO_DATE('18/02/2015', 'dd/mm/yyyy'));
  155. INSERT INTO note VALUES ('116', '22', 10, TO_DATE('20/02/2015', 'dd/mm/yyyy'));
  156. INSERT INTO note VALUES ('116', '23',  9, TO_DATE('21/06/2015', 'dd/mm/yyyy'));
  157.  
  158. INSERT INTO note VALUES ('117', '21',  7, TO_DATE('18/02/2015', 'dd/mm/yyyy'));
  159. INSERT INTO note VALUES ('117', '22',  6, TO_DATE('20/02/2015', 'dd/mm/yyyy'));
  160. INSERT INTO note VALUES ('117', '23',  4, TO_DATE('25/06/2015', 'dd/mm/yyyy'));
  161.  
  162. INSERT INTO note VALUES ('118', '21',  7, TO_DATE('22/02/2015', 'dd/mm/yyyy'));
  163. INSERT INTO note VALUES ('118', '22',  7, TO_DATE('24/02/2015', 'dd/mm/yyyy'));
  164. INSERT INTO note VALUES ('118', '23',  7, TO_DATE('21/06/2015', 'dd/mm/yyyy'));
  165.  
  166. INSERT INTO note VALUES ('119', '21',  7, TO_DATE('18/02/2015', 'dd/mm/yyyy'));
  167. INSERT INTO note VALUES ('119', '22',  8, TO_DATE('20/02/2015', 'dd/mm/yyyy'));
  168. INSERT INTO note VALUES ('119', '23',  9, TO_DATE('21/06/2015', 'dd/mm/yyyy'));
  169.  
  170.  
  171.  
  172. INSERT INTO profesori VALUES('p20', 'PASCARIU', 'GEORGIANA', NULL);
  173. INSERT INTO profesori VALUES('p21', 'LAZAR', 'LUCIAN', NULL);
  174. INSERT INTO profesori VALUES('p22', 'Kristo', 'ROBERT', NULL);
  175. INSERT INTO profesori VALUES('p20', 'Nastasa', 'Laura', NULL);
  176. INSERT INTO profesori VALUES('p21', 'PASAT', 'Tiberiu', NULL);
  177.  
  178. COMMIT;
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!