API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 16th, 2019
258
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.33 KB | None | 0 0
raw download clone embed print report
  1. #source C:/Users/enifl/Desktop/prBD.sql;
  2.  
  3.  
  4. DROP DATABASE ProfesoriDB;
  5. CREATE DATABASE ProfesoriDB;
  6. USE ProfesoriDB;
  7.  
  8.  
  9. CREATE TABLE tblAdresa(
  10. idAdresa INT(3) ZEROFILL PRIMARY KEY AUTO_INCREMENT,
  11. strada VARCHAR(256),
  12. codPostal CHAR(6),
  13. numar VARCHAR(3),
  14. oras VARCHAR(50),
  15. tara VARCHAR(50)
  16. );
  17. CREATE TABLE tblTipuriProiecte(
  18. idTipProiect INT(3) ZEROFILL PRIMARY KEY AUTO_INCREMENT,
  19. tipProiect VARCHAR(200),
  20. codRecunoastere VARCHAR(3)
  21. );
  22. CREATE TABLE tblProiect(
  23. WOS CHAR (15) PRIMARY KEY,
  24. titlu VARCHAR(256),
  25. editura VARCHAR(256),
  26. nrPagini SMALLINT,
  27. nrAni SMALLINT,
  28. punctaj DEC(4,2),
  29. idTipProiect INT(3) ZEROFILL,
  30. CONSTRAINT fk_idTipProiect FOREIGN KEY (idTipProiect)
  31. REFERENCES tblTipuriProiecte(idTipProiect) ON DELETE CASCADE ON UPDATE CASCADE
  32. );
  33. CREATE TABLE tblUniversitate(
  34. idUniversitate INT(3) ZEROFILL PRIMARY KEY AUTO_INCREMENT,
  35. numeUniversitate VARCHAR(256),
  36. clasament SMALLINT,
  37. emailSecretariat VARCHAR(256),
  38. anInfiintare YEAR,
  39. formaFinantare VARCHAR(8),
  40. codAdresa INT(3) ZEROFILL,
  41. CONSTRAINT fk_codAdresa FOREIGN KEY (codAdresa)
  42. REFERENCES tblAdresa(idAdresa) ON DELETE CASCADE ON UPDATE CASCADE
  43.  
  44. );
  45.  
  46. CREATE TABLE tblTipPrelegeri(
  47. idTipPrelegere INT(3) ZEROFILL PRIMARY KEY AUTO_INCREMENT,
  48. tip VARCHAR(50),
  49. nrOre INT(1)
  50. );
  51. CREATE TABLE tblPrelegeri(
  52. idPrelegere INT(4) ZEROFILL PRIMARY KEY AUTO_INCREMENT,
  53. numePrelegere VARCHAR(256),
  54. curriculum CHAR(1),
  55. sala VARCHAR(5),
  56. anStudiu CHAR (2),
  57. codTipPrelegere INT(3) ZEROFILL,
  58. CONSTRAINT fk_idTipPrelegere FOREIGN KEY (codTipPrelegere)
  59. REFERENCES tblTipPrelegeri (idTipPrelegere) ON DELETE CASCADE ON UPDATE CASCADE,
  60. codUniversitate INT(3) ZEROFILL,
  61. CONSTRAINT fk_codUniversitate FOREIGN KEY (codUniversitate)
  62. REFERENCES tblUniversitate(idUniversitate) ON DELETE CASCADE ON UPDATE CASCADE
  63.  
  64.  
  65. );
  66. CREATE TABLE tblProfesor(
  67. idProfesor INT(3) ZEROFILL PRIMARY KEY AUTO_INCREMENT ,
  68. numeProfesor VARCHAR(256),
  69. grad VARCHAR(50),
  70. telefon CHAR(10),
  71. codWOS CHAR(15),
  72. codPrelegere INT(4) ZEROFILL,
  73. CONSTRAINT fk_codWOS FOREIGN KEY (codWOS)
  74. REFERENCES tblProiect(WOS) ON DELETE CASCADE ON UPDATE CASCADE,
  75. CONSTRAINT fk_codPrelegere FOREIGN KEY (codPrelegere)
  76. REFERENCES tblPrelegeri(idPrelegere) ON DELETE CASCADE ON UPDATE CASCADE
  77. );
  78. INSERT INTO tblTipuriProiecte VALUES(001, "Activitate didactica si profesionala", "A1");
  79. INSERT INTO tblTipuriProiecte VALUES(101, "Activitate de cercetare", "Q1");
  80. INSERT INTO tblTipuriProiecte VALUES(NULL, "Activitate didactica si profesionala", "A1");
  81. INSERT INTO tblTipuriProiecte VALUES(009, "Activitate didactica si profesionala", 5);
  82. INSERT INTO tblTipuriProiecte VALUES(NULL, "", "A1");
  83. INSERT INTO tblTipuriProiecte VALUES(NULL, "Activitate de cercetare", "A2");
  84. INSERT INTO tblTipuriProiecte VALUES(201, "Activitate de cercetare", "Q2");
  85. INSERT INTO tblTipuriProiecte VALUES(202, "Activitate didactica si profesionala", NULL);
  86. INSERT INTO tblTipuriProiecte VALUES(500, "Activitate didactica si profesionala", NULL);
  87. INSERT INTO tblTipuriProiecte VALUES(550, "Activitate didactica si profesionala", "A1");
  88. INSERT INTO tblTipuriProiecte VALUES(444, "Activitate didactica si profesionala", "A1");
  89.  
  90.  
  91. INSERT INTO tblProiect VALUES("978146662940060", "Video Segmentation and Structuring for Indexing applications","IGI Global Printing House",25,1,12.5,001);
  92. INSERT INTO tblProiect VALUES("978606515380600", "Sisteme de compresie si codare video", "Editura Politehnica Press", 118,1,25.00, 001);
  93. INSERT INTO tblProiect VALUES("978606515506380", "Retele de comunicatii si sisteme multimedia", "Editura Politehnica Press", 194, 1, 25.00, 001);
  94. INSERT INTO tblProiect VALUES("978606551088300", "Design si procesare imagistica", "Editura Cavaliotti",259, 2, 16.17, 001);
  95. INSERT INTO tblProiect VALUES("000462912600043", "A Multimodal Subtitle Positioning System Dedicated to Deaf and Hearing-Impaired People", "IEEE Access", 12, 1, 4.09,101);
  96. INSERT INTO tblProiect VALUES("000476810500044", "Design of a CNN Face Recognition System Dedicated in Blinds", "ICCE", 2, 5, 0.25, 201);
  97. INSERT INTO tblProiect VALUES("000469225840019", "Face Recognition in Video Streams for Mobile Assistive Devices Dedicated to Visually Impaired", "SITIS", 5, 2, 10.83, 201);
  98. INSERT INTO tblProiect VALUES("000447704600001", "A Mobile Face Recognition System Dedicated to Visually Impaired People", "IEEE Access", 10, 9, 49.31, 101);
  99. INSERT INTO tblProiect VALUES("000400845000037", "A computer vision-based system for visually impaired", "ICCV", 17, 7, 29.34, 201);
  100. INSERT INTO tblProiect VALUES("000389641700040", "When Ultrasonic Sensors and Computer Vision Join Resources for Efficient Obstacle Detection and Recognition", "Sensors",7,2,0.25, 101);
  101.  
  102. INSERT INTO tblTipPrelegeri VALUES (3, "Curs", 2);
  103. INSERT INTO tblTipPrelegeri VALUES (985, "Proiect", 1);
  104. INSERT INTO tblTipPrelegeri VALUES (487, "Laborator", 1);
  105. INSERT INTO tblTipPrelegeri VALUES (887, "Seminar", 2);
  106.  
  107. INSERT INTO tblAdresa VALUES(662,"Bd. Iuliu Maniu", 800642, 1, "Bucuresti", "Romania");
  108. INSERT INTO tblAdresa VALUES(987,"Str. Ion Ghica", 124522,13, "Bucuresti", "Romania");
  109. INSERT INTO tblAdresa VALUES(243, "Rue Charles Fourier", NULL, 9, "Evry", "France");
  110. INSERT INTO tblAdresa VALUES(254, "Strada Atomistilor", 777125, 405, "Bucuresti-Magurele", "Romania");
  111. INSERT INTO tblAdresa VALUES(225, "Bd. George Cosbuc", 050141, 39, "Bucuresti", "Romania");
  112. INSERT INTO tblAdresa VALUES(111, "Str Stiintei", 800146, 2, "Galati", "Romania");
  113. INSERT INTO tblAdresa VALUES(999, "Hills Road", NULL, 184, "Cambridge", "United Kingdom");
  114. INSERT INTO tblAdresa VALUES(642, "Prof. dr. doc. Dimitrie Mangeron", 987621, 27, "Iasi", "Romania");
  115. INSERT INTO tblAdresa VALUES(748, "Str. G. Baritiu", 400027, 26, "Cluj-Napoca", "Romania");
  116. INSERT INTO tblAdresa VALUES(664, "Bd. Vasile Parvan", 300223, 2, "Timisoara", "Romania");
  117. INSERT INTO tblAdresa VALUES(563, "Calea Dorobanti", 010552, 15, "Bucuresti", "Romania");
  118.  
  119. INSERT INTO tblUniversitate VALUES(DEFAULT, "Universitatea Politehnica din Bucuresti", 1283, "relatii.publice@upb.ro", 1918, "stat", 662);
  120. INSERT INTO tblUniversitate VALUES(DEFAULT, "Academia Tehnica Militara", NULL, "relatii.publice@mta.ro", 1949, "stat", 225);
  121. INSERT INTO tblUniversitate VALUES(DEFAULT, "Telecom Sud-paris", 56, "communication@telecom-sudparis.eu",1979, "privat", 243);
  122. INSERT INTO tblUniversitate VALUES(DEFAULT, "Facultatea de Fizica", 1345, "secretariat@fizica.unibuc.ro", 1901, "stat", 254);
  123. INSERT INTO tblUniversitate VALUES(DEFAULT, "Facultatea de Matematica si Informatica", 880, "secretariat@fmi.ro", 1970, "stat", 987);
  124. INSERT INTO tblUniversitate VALUES(DEFAULT, "Universitatea Politehnica din Galati", 2251, "secretariat@ugal.ro", 1923, "stat", 111);
  125. INSERT INTO tblUniversitate VALUES(DEFAULT, "Cambridge University", 2, "admissions@cam.ac.uk", 1901, "privat", 999);
  126. INSERT INTO tblUniversitate VALUES(DEFAULT, "Universitatea Alexandru Ioan Cuza din Iasi", 1345, "secretariat@uaic.ro", 1935, "stat", 642);
  127. INSERT INTO tblUniversitate VALUES(DEFAULT, "Universitatea Tehnica din Cluj-Napoca", 1284, "contact@utcluj.ro", 1922, "stat", 748);
  128. INSERT INTO tblUniversitate VALUES(DEFAULT, "Universitatea Tehnica din Timisoara", 1285, "contact@uta.ro", 1930, "stat", 664);
  129. INSERT INTO tblUniversitate VALUES(DEFAULT, "Cibernetica Statistica si Informatica Economica", 900, "secretariat@csie.ro", 1915, "stat", 563);
  130.  
  131. INSERT INTO tblPrelegeri VALUES(1000, "Semnale si sisteme", 'O', 'R205', 2, 3, 1); #done
  132. INSERT INTO tblPrelegeri VALUES(1001, "Semnale si sisteme", 'O', 'B205', 2, 487, 1); #done
  133. INSERT INTO tblPrelegeri VALUES(1002, "Semnale si sisteme", 'O', 'B206', 2, 985, 1);#done
  134. INSERT INTO tblPrelegeri VALUES(1003, "Semnale si sisteme", 'O', 'B11', 2, 887, 1); #done
  135. INSERT INTO tblPrelegeri VALUES(1004, "Semnale si sisteme", 'O', '10252', 3, 3, 2); #done
  136. INSERT INTO tblPrelegeri VALUES(1005, "Semnale si sisteme", 'O', '10052', 3, 487, 2); #done
  137. INSERT INTO tblPrelegeri VALUES(1006, "Baze de date", 'O', 'B206', 4, 3, 1); #done
  138. INSERT INTO tblPrelegeri VALUES(1007, "Baze de date", 'O', '2218', 2, 3, 11); #done
  139. INSERT INTO tblPrelegeri VALUES(1008, "Metode numerice", 'A','A305', 2, 3, 1); #done
  140. INSERT INTO tblPrelegeri VALUES(1009, "Metode numerice", 'A', 'A651', 2, 487, 1); #done
  141. INSERT INTO tblPrelegeri VALUES(1010, "Baze de date", 'O', 'B02', 4, 487, 1); #done
  142. INSERT INTO tblPrelegeri VALUES(1011, "Fizica 1", 'O', 'B219a', 1, 3, 1);#done
  143. INSERT INTO tblPrelegeri VALUES(1012, "Fizica 1", 'O', 'N17', 1, 3, 3); #done
  144. INSERT INTO tblPrelegeri VALUES(1013, "Fizica 1", 'O', 'AH3072', 2, 3, 4); #done
  145. INSERT INTO tblPrelegeri VALUES(1014, "Fizica 1", 'O', 'X123', 2, 3, 6); #done
  146. INSERT INTO tblPrelegeri VALUES(1015, "Procedural Programming",'O','V125', 1, 3, 7); #done
  147. INSERT INTO tblPrelegeri VALUES(1016, "Programarea Calculatoarelor", 'O', 'I986', 1, 3, 8); #done
  148. INSERT INTO tblPrelegeri VALUES(1017, "Structuri de Date" ,'O', 'C098', 1, 3, 9);
  149. INSERT INTO tblPrelegeri VALUES(1018, "Algoritmici si Euristica de baza", 'O', 'T5346', 1,3,10);
  150. INSERT INTO tblPrelegeri VALUES(1019, "Calcul Paralel", 'L', '1235', 3, 3, 5);
  151.  
  152. select tblUniversitate.numeUniversitate from tblUniversitate left join tblPrelegeri on tblPrelegeri.codUniversitate = tblUniversitate.idUniversitate
  153. where tblPrelegeri.idPrelegere = 1012;
  154.  
  155.  
  156. INSERT INTO tblProfesor VALUES(100, "Cristian Negrescu", "Profesor Universitar", "0712345678", "000476810500044", 1000);
  157. INSERT INTO tblProfesor VALUES(101, "Cristian Negrescu", "Profesor Universitar", "0712345678", "000476810500044", 1004);
  158. INSERT INTO tblProfesor VALUES(102, "Bogdan Mocanu", "Profesor Universitar", "0758629183", "000400845000037",1006);
  159. INSERT INTO tblProfesor VALUES(103, "Bogdan Mocanu", "Profesor Universitar", "0758629183", "000400845000037",1007);
  160. INSERT INTO tblProfesor VALUES(104, "Bogdan Mocanu", "Profesor Universitar", "0758629183", "000476810500044",1006);
  161. INSERT INTO tblProfesor VALUES(105, "Bogdan Mocanu", "Profesor Universitar", "0758629183", "000389641700040",1006);
  162. INSERT INTO tblProfesor VALUES(106, "Robert Dobre", "Asistent Universitar", "0336123565", NULL, 1001);
  163. INSERT INTO tblProfesor VALUES(107, "Robert Dobre", "Asistent Universitar", "0336123565", NULL, 1002);
  164. INSERT INTO tblProfesor VALUES(108, "Victor Popa", "Conferentiar Universitar", "0770770770", "978606515380600", NULL);
  165. INSERT INTO tblProfesor VALUES(109, "Victor Popa", "Conferentiar Universitar", "0770770770", "978606515506380", 1003);
  166. INSERT INTO tblProfesor VALUES(110, "Victor Popa", "Conferentiar Universitar", "0770770770", "978606515506380", 1005);
  167. INSERT INTO tblProfesor VALUES(111, "Serban Mihalache", "Lector Universitar", "0758102575", "000469225840019", 1008);
  168. INSERT INTO tblProfesor VALUES(112, "Robert Simion", "Asistent Universitar", "0748780318", NULL, 1009);
  169. INSERT INTO tblProfesor VALUES(113, "Oana Florea", "Conferentiar Universitar", "0751611834", "000447704600001", 1010);
  170. INSERT INTO tblProfesor VALUES(114, "Mihai Stafe", "Conferentiar Universitar", "0751302924", "000462912600043", 1011);
  171. INSERT INTO tblProfesor VALUES(115, "Mihai Stafe", "Conferentiar Universitar", "0751302924", "000462912600043", 1012);
  172. INSERT INTO tblProfesor VALUES(116, "Alexandru Lupascu", "Profesor Universitar", "0751302924", "978606515506380", 1013);
  173. INSERT INTO tblProfesor VALUES(117, "Alexandru Lupascu", "Profesor Universitar", "0751302924", "978606515506380", 1014);
  174. INSERT INTO tblProfesor VALUES(118, "Bogdan Ionescu", "Profesor Universitar", "0724512345","978146662940060", 1015);
  175. INSERT INTO tblProfesor VALUES(119, "Bogdan Ionescu", "Profesor Universitar", "0724512345","978606551088300", 1016);
  176. INSERT INTO tblProfesor VALUES(120, "Cristian Oara", "Profesor Universitar", "0714029167", "000389641700040", 1017);
  177. INSERT INTO tblProfesor VALUES(121, "Cristian Oara", "Profesor Universitar", "0714029167", "000389641700040", 1018);
  178. INSERT INTO tblProfesor VALUES(122, "Aurelian Tanasescu", "Profesor Universitar", "0768989098", "000447704600001", 1019);
  179. SELECT * FROM tblProfesor;
  180. /*CREATE TABLE tblProfesor(
  181. idProfesor INT(3) ZEROFILL PRIMARY KEY AUTO_INCREMENT ,
  182. numeProfesor VARCHAR(256),
  183. grad VARCHAR(50),
  184. telefon CHAR(10),
  185. codWOS CHAR(15),
  186. codPrelegere INT(3) ZEROFILL,
  187. CONSTRAINT fk_codWOS FOREIGN KEY (codWOS)
  188. REFERENCES tblProiect(WOS) ON DELETE CASCADE ON UPDATE CASCADE,
  189. CONSTRAINT fk_codPrelegere FOREIGN KEY (codPrelegere)
  190. REFERENCES tblPrelegeri(idPrelegere) ON DELETE CASCADE ON UPDATE CASCADE
  191. );*/
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!