API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 14th, 2018
630
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQF 48.85 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. *****************************
  3. ******* TABLE CREATION ******
  4. *****************************
  5. */
  6. CREATE TABLE persoane (
  7.     id_persoana   NUMBER(3),
  8.     nume         VARCHAR2(20)  NOT NULL,
  9.     prenume       VARCHAR2(20)  NOT NULL,
  10.     telefon       VARCHAR2(15),
  11.     e_mail       VARCHAR2(40),
  12.     data_nasterii DATE          NOT NULL,
  13.     sex           CHAR(1)       CHECK (sex = 'M' OR sex = 'F'),
  14.     rol           CHAR(1)       NOT NULL
  15.                                 CHECK (rol in ('P', 'C', 'V')),
  16.     CONSTRAINT contact     CHECK ((telefon IS NOT NULL) OR
  17.                                   (e_mail IS NOT NULL)),
  18.     CONSTRAINT pk_persoane PRIMARY KEY (id_persoana, rol),
  19.     CONSTRAINT is_email   CHECK (e_mail LIKE ('%_%@%_%.%_%')),
  20.     CONSTRAINT is_phone   CHECK (REGEXP_LIKE (telefon,
  21.                                                '^[0-9]{3}-[0-9]{3}-[0-9]{4}$'))
  22. );
  23.  
  24. CREATE TABLE participanti (
  25.     id_participant NUMBER(3)   UNIQUE,
  26.     tara_origine   VARCHAR2(20) NOT NULL,
  27.     oras_origine   VARCHAR2(20) NOT NULL,
  28.     tara_resedinta VARCHAR2(20) NOT NULL,
  29.     oras_resedinta VARCHAR2(20) NOT NULL,
  30.     stare_civila   VARCHAR2(15) NOT NULL,
  31.     loc_munca     VARCHAR2(30),
  32.     grad_academic VARCHAR2(10),
  33.     rol           CHAR(1)      DEFAULT('P')
  34.                                 NOT NULL
  35.                                 CHECK (rol = 'P'),
  36.     CONSTRAINT is_grad_academic CHECK (grad_academic IN ('DOCTORAT',
  37.                                                          'MASTERAT',
  38.                                                          'LICENTA')),
  39.     CONSTRAINT is_stare_civila CHECK (stare_civila IN ('CASATORIT',
  40.                                                         'NECASATORIT',
  41.                                                         'CASATORITA',
  42.                                                         'NECASATORITA')),
  43.     CONSTRAINT pk_part     PRIMARY KEY (id_participant, rol),
  44.     CONSTRAINT fk_part_pers FOREIGN KEY (id_participant, rol)
  45.                               REFERENCES persoane (id_persoana, rol)
  46.                                 ON DELETE CASCADE
  47. );
  48.  
  49. CREATE TABLE facultati (
  50.     id_facultate NUMBER(2)   PRIMARY KEY,
  51.     nume         VARCHAR2(60) NOT NULL,
  52.     universitate VARCHAR2(60) NOT NULL,
  53.     adresa       VARCHAR2(50) NOT NULL
  54. );
  55.  
  56. CREATE TABLE voluntari (
  57.     id_voluntar NUMBER(3)   UNIQUE,
  58.     grupa       VARCHAR2(5) NOT NULL,
  59.     id_facultate NUMBER(2)   NOT NULL,
  60.     rol         CHAR(1)     DEFAULT('V')
  61.                              NOT NULL
  62.                             CHECK (rol = 'V'),
  63.     CONSTRAINT pk_vol     PRIMARY KEY (id_voluntar, rol),
  64.     CONSTRAINT fk_vol_fac FOREIGN KEY (id_facultate)
  65.                             REFERENCES facultati (id_facultate),
  66.     CONSTRAINT fk_vol_pers FOREIGN KEY (id_voluntar, rol)
  67.                             REFERENCES persoane (id_persoana, rol)
  68.                               ON DELETE CASCADE
  69. );
  70.  
  71. CREATE TABLE chestionare (
  72.     nr_chestionar     NUMBER(3) PRIMARY KEY,
  73.     data_inregistrare DATE      NOT NULL,
  74.     scor_SO           NUMBER(3) NOT NULL,
  75.     scor_OO           NUMBER(3) NOT NULL,
  76.     scor_SP           NUMBER(3) NOT NULL,
  77.     id_voluntar       NUMBER(3),
  78.     id_participant   NUMBER(3) UNIQUE
  79.                                 NOT NULL,
  80.     CONSTRAINT fk_chest_vol FOREIGN KEY (id_voluntar)
  81.                               REFERENCES voluntari (id_voluntar),
  82.     CONSTRAINT fk_chest_part FOREIGN KEY (id_participant)
  83.                               REFERENCES participanti (id_participant)
  84. );
  85.  
  86. CREATE TABLE intrebari (
  87.     nr_intrebare NUMBER(2)     PRIMARY KEY,
  88.     descriere     VARCHAR2(100) NOT NULL,
  89.     tip_intrebare CHAR(2)       NOT NULL
  90.                                 CHECK (tip_intrebare IN ('SO', 'OO', 'SP'))
  91. );
  92.  
  93. CREATE TABLE raspunsuri (
  94.     grad_acord     NUMBER(1) NOT NULL
  95.                             CHECK (grad_acord BETWEEN 0 AND 7),
  96.     nr_intrebare   NUMBER(2),
  97.     id_participant NUMBER(3),
  98.     CONSTRAINT pk_raspunsuri PRIMARY KEY (nr_intrebare, id_participant),
  99.     CONSTRAINT fk_rasp_intreb FOREIGN KEY (nr_intrebare)
  100.                                 REFERENCES intrebari (nr_intrebare),
  101.     CONSTRAINT fk_rasp_part   FOREIGN KEY (id_participant)
  102.                                 REFERENCES participanti (id_participant)
  103. );
  104.  
  105. CREATE TABLE laboratoare (
  106.     nr_sala NUMBER(3) PRIMARY KEY
  107. );
  108.  
  109. CREATE TABLE calculatoare (
  110.     nr_calculator NUMBER(2),
  111.     nr_sala       NUMBER(3) NOT NULL,
  112.     CONSTRAINT pk_calc     PRIMARY KEY (nr_calculator, nr_sala),
  113.     CONSTRAINT fk_calc_lab FOREIGN KEY (nr_sala)
  114.                             REFERENCES laboratoare (nr_sala)
  115. );
  116.  
  117. CREATE TABLE experimente (
  118.     id_experiment   NUMBER(2) PRIMARY KEY,
  119.     data_experiment DATE      NOT NULL,
  120.     nr_sala         NUMBER(3) NOT NULL,
  121.     CONSTRAINT fk_exp_lab FOREIGN KEY (nr_sala)
  122.                             REFERENCES laboratoare (nr_sala)
  123. );
  124.  
  125. CREATE TABLE cercetatori (
  126.     id_cercetator NUMBER(3)   UNIQUE,
  127.     domeniu_studiu VARCHAR2(30) NOT NULL,
  128.     functie       VARCHAR2(20) NOT NULL,
  129.     id_experiment NUMBER(2),
  130.     rol           CHAR(1)      DEFAULT ('C')
  131.                                 CHECK (rol = 'C'),
  132.     id_facultate   NUMBER(2),
  133.     CONSTRAINT pk_cer     PRIMARY KEY (id_cercetator, rol),
  134.     CONSTRAINT fk_cer_pers FOREIGN KEY (id_cercetator, rol)
  135.                             REFERENCES persoane (id_persoana, rol),
  136.     CONSTRAINT fk_cer_exp FOREIGN KEY (id_experiment)
  137.                             REFERENCES experimente (id_experiment),
  138.     CONSTRAINT fk_cer_fac FOREIGN KEY (id_facultate)
  139.                             REFERENCES facultati (id_facultate)
  140. );                            
  141.  
  142. CREATE TABLE rezultate_experimente (
  143.     id_rezultat       NUMBER(2) PRIMARY KEY,
  144.     scor_stima         NUMBER(2) NOT NULL,
  145.     scor_depresie     NUMBER(2) NOT NULL,
  146.     scor_anxietate     NUMBER(2) NOT NULL,
  147.     scor_vina         NUMBER(2) NOT NULL,
  148.     scor_procrastinare NUMBER(2) NOT NULL,
  149.     id_experiment     NUMBER(2) NOT NULL,
  150.     id_participant     NUMBER(3) UNIQUE
  151.                                  NOT NULL,
  152.     CONSTRAINT fk_rez_exp FOREIGN KEY (id_experiment)
  153.                             REFERENCES experimente (id_experiment),
  154.     CONSTRAINT fk_rez_part FOREIGN KEY (id_participant)
  155.                             REFERENCES participanti (id_participant)
  156. );
  157.  
  158.  
  159.  
  160.  
  161.  
  162.  
  163.  
  164.  
  165.  
  166.  
  167. /*
  168. *******************************
  169. ******* TABLE POPULATION ******
  170. *******************************
  171. */
  172.  
  173. -- PERSOANE DATA
  174. INSERT INTO persoane VALUES (300,'Andra','Mirela','077-276-2879','mirela.andra@fmi.ro','23-07-1979','F','C');
  175. INSERT INTO persoane VALUES (301,'Iancu','Nicolae','074-201-3238','nicolae.iancu@fmi.ro','19-12-1979','M','C');
  176. INSERT INTO persoane VALUES (302,'Luiza','Viorel','073-194-6568','viorel.luiza@gmail.com','29-06-1982','F','C');
  177. INSERT INTO persoane VALUES (303,'Silva','David','075-800-9059','david.silva@hotmail.com','23-07-1982','M','C');
  178. INSERT INTO persoane VALUES (400,'Ileana','Horia','075-609-3010','horia.ileana@yahoo.com','18-07-1979','F','V');
  179. INSERT INTO persoane VALUES (401,'Valerian','Lidia','073-273-8806','lidia.valerian@bing.com','09-03-1978','F','V');
  180. INSERT INTO persoane VALUES (402,'Adrian','Horia','077-860-6875','horia.adrian@fmi.unibuc.ro','08-02-1990','M','V');
  181. INSERT INTO persoane VALUES (403,'Lavinia','Daniel','077-388-8947','daniel.lavinia@yahoo.com','30-01-1982','M','V');
  182. INSERT INTO persoane VALUES (404,'Nelu','Tiberiu','075-790-4122','tiberiu.nelu@gmail.com','14-03-1985','M','V');
  183. INSERT INTO persoane VALUES (405,'Viorica','Amalia','077-399-3398','amalia.viorica@yahoo.com','02-08-1980','F','V');
  184. INSERT INTO persoane VALUES (406,'Minodora','Andreea','073-761-3972','andreea.minodora@gmail.com','12-01-1987','F','V');
  185. INSERT INTO persoane VALUES (407,'Iuliu','Silviu','073-942-1840','silviu.iuliu@gmail.com','02-11-1980','M','V');
  186. INSERT INTO persoane VALUES (408,'Luca','Adina','077-404-9353','adina.luca@gmail.com','30-11-1978','F','V');
  187. INSERT INTO persoane VALUES (409,'Angelica','Sofia','074-728-1190','sofia.angelica@bing.com','28-12-1987','F','V');
  188. INSERT INTO persoane VALUES (410,'Decebal','Valerian','077-414-7466','valerian.decebal@bing.com','21-04-1980','M','V');
  189. INSERT INTO persoane VALUES (500,'Andreea','Marta','073-327-6744','marta.andreea@bing.com','30-04-1984','F','P');
  190. INSERT INTO persoane VALUES (501,'Pompiliu','Daniela','073-225-5351','daniela.pompiliu@bing.com','25-01-1994','F','P');
  191. INSERT INTO persoane VALUES (502,'Darius','Stelian','076-981-3657','stelian.darius@aol.com','14-10-1984','M','P');
  192. INSERT INTO persoane VALUES (503,'David','Marta','072-154-4915','marta.david@yahoo.com','27-08-1987','F','P');
  193. INSERT INTO persoane VALUES (504,'Simion','Victor','074-205-7725','victor.simion@yahoo.com','04-08-1983','M','P');
  194. INSERT INTO persoane VALUES (505,'Miruna','Sandu','076-435-7959','sandu.miruna@fmi.unibuc.ro','28-04-1992','M','P');
  195. INSERT INTO persoane VALUES (506,'Serafim','Alexandra','074-925-9823','alexandra.serafim@bing.com','23-02-1993','F','P');
  196. INSERT INTO persoane VALUES (507,'Demetra','Dragos','073-767-4560','dragos.demetra@bing.com','26-10-1986','M','P');
  197. INSERT INTO persoane VALUES (508,'Anghel','Anca','072-201-1291','anca.anghel@hotmail.com','25-03-1986','F','P');
  198. INSERT INTO persoane VALUES (509,'Fane','Lucian','074-372-7451','lucian.fane@bing.com','06-10-1994','M','P');
  199. INSERT INTO persoane VALUES (510,'Horatiu','Iuliana','077-437-1060','iuliana.horatiu@fmi.unibuc.ro','30-03-1981','F','P');
  200. INSERT INTO persoane VALUES (511,'Albert','Adelina','073-940-1434','adelina.albert@bing.com','23-03-1988','F','P');
  201. INSERT INTO persoane VALUES (512,'Pompiliu','Liana','076-590-3184','liana.pompiliu@aol.com','14-06-1996','F','P');
  202. INSERT INTO persoane VALUES (513,'Daciana','Roxana','073-542-2027','roxana.daciana@bing.com','11-09-1985','F','P');
  203. INSERT INTO persoane VALUES (514,'Aurora','Crina','074-849-5029','crina.aurora@fmi.unibuc.ro','18-12-1990','F','P');
  204.  
  205.  
  206. -- PARTICIPANTI DATA
  207. INSERT INTO participanti VALUES (500,'Romania','Bucuresti','Romania','Bucuresti','CASATORITA','manuitor valori','LICENTA',DEFAULT);
  208. INSERT INTO participanti VALUES (501,'Romania','Mogosoaia','Romania','Mogosoaia','NECASATORITA','operator dispecerat',NULL,DEFAULT);
  209. INSERT INTO participanti VALUES (502,'Romania','Brasov','Romania','Brasov','NECASATORIT','arhitect','MASTERAT',DEFAULT);
  210. INSERT INTO participanti VALUES (503,'Romania','Videle','Romania','Bucuresti','CASATORITA','head of server','LICENTA',DEFAULT);
  211. INSERT INTO participanti VALUES (504,'Romania','Bucuresti','Romania','Bucuresti','CASATORIT','office assistant','LICENTA',DEFAULT);
  212. INSERT INTO participanti VALUES (505,'Romania','Arad','Romania','Bucuresti','NECASATORIT','manager vanzari','MASTERAT',DEFAULT);
  213. INSERT INTO participanti VALUES (506,'Romania','Galati','Romania','Galati','CASATORITA','operator de trafic','LICENTA',DEFAULT);
  214. INSERT INTO participanti VALUES (507,'Romania','Breaza','Romania','Bucuresti','NECASATORIT','asistent social',NULL,DEFAULT);
  215. INSERT INTO participanti VALUES (508,'Romania','Bucuresti','Romania','Bucuresti','CASATORITA','operator depozit',NULL,DEFAULT);
  216. INSERT INTO participanti VALUES (509,'Romania','Sfantu Gheorghe','Romania','Bucuresti','NECASATORIT','operator baze de date','MASTERAT',DEFAULT);
  217. INSERT INTO participanti VALUES (510,'Romania','Brasov','Romania','Brasov','CASATORITA','hidrometeorolog','DOCTORAT',DEFAULT);
  218. INSERT INTO participanti VALUES (511,'Romania','OneÅŸti','Romania','Bucuresti','NECASATORITA','agent achizitii','LICENTA',DEFAULT);
  219. INSERT INTO participanti VALUES (512,'Romania','Motru','Romania','Bucuresti','CASATORITA','asistent manager','MASTERAT',DEFAULT);
  220. INSERT INTO participanti VALUES (514,'Romania','Pitesti','Romania','Pitesti','CASATORITA','operator collection','LICENTA',DEFAULT);
  221. INSERT INTO participanti VALUES (513,'Romania','Chitila','Romania','Chitila','NECASATORITA','operator call center',NULL,DEFAULT);
  222.  
  223.  
  224. -- FACULTATI DATA
  225. INSERT INTO facultati VALUES (10, 'Facultatea de Psihologie si Stiintele Educatiei', 'Universitatea din Bucuresti', 'Sos. Panduri nr. 90, sector 5, Bucuresti');
  226. INSERT INTO facultati VALUES (11, 'Facultatea de Psihologie si Stiinte ale Educatiei', 'Universitatea Babes-Bolyai', 'Str. Republicii nr. 37, Cluj-Napoca, jud. Cluj');
  227. INSERT INTO facultati VALUES (12, 'Facultatea de Sociologie si Asistenta Sociala', 'Universitatea din Bucuresti', 'Str. Schitu Magureanu 9 sector 5, Bucuresti');
  228.  
  229.  
  230. -- VOLUNTARI DATA
  231. INSERT INTO voluntari VALUES (400,'251',10,DEFAULT);
  232. INSERT INTO voluntari VALUES (401,'231',10,DEFAULT);
  233. INSERT INTO voluntari VALUES (402,'331',10,DEFAULT);
  234. INSERT INTO voluntari VALUES (403,'230',10,DEFAULT);
  235. INSERT INTO voluntari VALUES (404,'430',11,DEFAULT);
  236. INSERT INTO voluntari VALUES (405,'430',11,DEFAULT);
  237. INSERT INTO voluntari VALUES (406,'430',10,DEFAULT);
  238. INSERT INTO voluntari VALUES (407,'431',10,DEFAULT);
  239. INSERT INTO voluntari VALUES (408,'422',11,DEFAULT);
  240. INSERT INTO voluntari VALUES (409,'421',10,DEFAULT);
  241. INSERT INTO voluntari VALUES (410,'422',11,DEFAULT);
  242.  
  243. -- CHESTIONARE DATA
  244. INSERT INTO chestionare VALUES (1,'31-1-2016',47,74,56,402,505);
  245. INSERT INTO chestionare VALUES (2,'19-6-2016',58,60,76,NULL,500);
  246. INSERT INTO chestionare VALUES (3,'20-5-2016',57,61,56,400,511);
  247. INSERT INTO chestionare VALUES (4,'18-1-2016',51,68,69,408,509);
  248. INSERT INTO chestionare VALUES (5,'28-5-2016',56,58,61,NULL,514);
  249. INSERT INTO chestionare VALUES (6,'7-4-2016',70,67,49,407,501);
  250. INSERT INTO chestionare VALUES (7,'2-2-2016',63,65,52,403,512);
  251. INSERT INTO chestionare VALUES (8,'13-5-2016',54,63,82,NULL,508);
  252. INSERT INTO chestionare VALUES (9,'15-6-2016',65,56,67,NULL,510);
  253. INSERT INTO chestionare VALUES (10,'8-4-2016',56,54,58,405,502);
  254. INSERT INTO chestionare VALUES (11,'13-2-2016',46,52,65,401,513);
  255. INSERT INTO chestionare VALUES (12,'28-5-2016',72,62,71,410,507);
  256. INSERT INTO chestionare VALUES (13,'23-5-2016',66,56,73,406,504);
  257. INSERT INTO chestionare VALUES (14,'6-4-2016',59,54,51,404,503);
  258. INSERT INTO chestionare VALUES (15,'3-3-2016',55,62,83,409,506);
  259.  
  260.  
  261. -- INTREBARI DATA
  262. INSERT INTO intrebari VALUES (1,'When I am working on something, I cannot relax until it is perfect','SO');
  263. INSERT INTO intrebari VALUES (2,'I am not likely to criticize someone for giving up too easily','OO');
  264. INSERT INTO intrebari VALUES (3,'It is not important that people I am close to are successful','OO');
  265. INSERT INTO intrebari VALUES (4,'I seldom criticize my friends for accepting second best','OO');
  266. INSERT INTO intrebari VALUES (5,'I find it difficult to meet others’ expectations of me','SP');
  267. INSERT INTO intrebari VALUES (6,'One of my goals is to be perfect in everything I do','SO');
  268. INSERT INTO intrebari VALUES (7,'Everything that others do must be of top-notch quality','OO');
  269. INSERT INTO intrebari VALUES (8,'I never aim for perfection on my work','SO');
  270. INSERT INTO intrebari VALUES (9,'Those around me readily accept that I can make mistakes too','SP');
  271. INSERT INTO intrebari VALUES (10,'It doesn’t matter when someone close to me does not do their absolute best','OO');
  272. INSERT INTO intrebari VALUES (11,'The better I do, the better I am expected to do','SP');
  273. INSERT INTO intrebari VALUES (12,'I seldom feel the need to be perfect','SO');
  274. INSERT INTO intrebari VALUES (13,'Anything that I do that is less than excellent will be seen as poor work by those around me','SP');
  275. INSERT INTO intrebari VALUES (14,'I strive to be as perfect as I can be','SO');
  276. INSERT INTO intrebari VALUES (15,'It is very important that I am perfect in everything I attempt','SO');
  277. INSERT INTO intrebari VALUES (16,'I have high expectations for the people who are important to me','OO');
  278. INSERT INTO intrebari VALUES (17,'I strive to be the best at everything I do','SO');
  279. INSERT INTO intrebari VALUES (18,'The people around me expect me to succeed at everything I do','SP');
  280. INSERT INTO intrebari VALUES (19,'I do not have very high standards for those around me','OO');
  281. INSERT INTO intrebari VALUES (20,'I demand nothing less than perfection of myself','SO');
  282. INSERT INTO intrebari VALUES (21,'Others will like me even if I don’t excel at everything','SP');
  283. INSERT INTO intrebari VALUES (22,'I can’t be bothered with people  who won’t strive to better themselves','OO');
  284. INSERT INTO intrebari VALUES (23,'It makes me uneasy to see an error in my work','SO');
  285. INSERT INTO intrebari VALUES (24,'I do not expect a lot from my friends','OO');
  286. INSERT INTO intrebari VALUES (25,'Success means that I must work even harder to please others','SP');
  287. INSERT INTO intrebari VALUES (26,'If I ask someone to do something, I expect it to be done flawlessly','OO');
  288. INSERT INTO intrebari VALUES (27,'I cannot stand to see people close to me make mistakes','OO');
  289. INSERT INTO intrebari VALUES (28,'I am perfectionistic in setting my goals','SO');
  290. INSERT INTO intrebari VALUES (29,'The people who matter to me should never let me down','OO');
  291. INSERT INTO intrebari VALUES (30,'Others think I am okay, even when I do not succeed','SP');
  292. INSERT INTO intrebari VALUES (31,'I feel that people are too demanding of me','SP');
  293. INSERT INTO intrebari VALUES (32,'I must work to my full potential at all times','SO');
  294. INSERT INTO intrebari VALUES (33,'Although they may not say it, other people get very upset with me when I slip up','SP');
  295. INSERT INTO intrebari VALUES (34,'I do not have to be the best at whatever I am doing','SO');
  296. INSERT INTO intrebari VALUES (35,'My family expects me to be perfect','SP');
  297. INSERT INTO intrebari VALUES (36,'I do not have very high goals for myself','SO');
  298. INSERT INTO intrebari VALUES (37,'My parent rarely expected me to excel in all aspects of my life','SP');
  299. INSERT INTO intrebari VALUES (38,'I respect people who are average','OO');
  300. INSERT INTO intrebari VALUES (39,'People expect nothing less than perfection from me','SP');
  301. INSERT INTO intrebari VALUES (40,'I set very high standards for myself','SO');
  302. INSERT INTO intrebari VALUES (41,'People expect more from me than I am capable of giving','SP');
  303. INSERT INTO intrebari VALUES (42,'I must always be successful at school or work','SO');
  304. INSERT INTO intrebari VALUES (43,'It does not matter to me when a close friend does not try their hardest','OO');
  305. INSERT INTO intrebari VALUES (44,'People around me think I am still competent even if I make a mistake','SP');
  306. INSERT INTO intrebari VALUES (45,'I seldom expect others to excel at whatever they do.','OO');
  307.  
  308.  
  309. -- RASPUNSURI DATA
  310. INSERT INTO laboratoare VALUES(210);
  311. INSERT INTO raspunsuri VALUES (7,7,500);
  312. INSERT INTO raspunsuri VALUES (2,8,500);
  313. INSERT INTO raspunsuri VALUES (7,9,500);
  314. INSERT INTO raspunsuri VALUES (2,10,500);
  315. INSERT INTO raspunsuri VALUES (5,11,500);
  316. INSERT INTO raspunsuri VALUES (5,12,500);
  317. INSERT INTO raspunsuri VALUES (5,13,500);
  318. INSERT INTO raspunsuri VALUES (3,14,500);
  319. INSERT INTO raspunsuri VALUES (2,15,500);
  320. INSERT INTO raspunsuri VALUES (1,16,500);
  321. INSERT INTO raspunsuri VALUES (7,17,500);
  322. INSERT INTO raspunsuri VALUES (6,18,500);
  323. INSERT INTO raspunsuri VALUES (6,19,500);
  324. INSERT INTO raspunsuri VALUES (7,20,500);
  325. INSERT INTO raspunsuri VALUES (7,21,500);
  326. INSERT INTO raspunsuri VALUES (4,22,500);
  327. INSERT INTO raspunsuri VALUES (5,23,500);
  328. INSERT INTO raspunsuri VALUES (4,24,500);
  329. INSERT INTO raspunsuri VALUES (4,25,500);
  330. INSERT INTO raspunsuri VALUES (4,26,500);
  331. INSERT INTO raspunsuri VALUES (2,27,500);
  332. INSERT INTO raspunsuri VALUES (6,28,500);
  333. INSERT INTO raspunsuri VALUES (5,29,500);
  334. INSERT INTO raspunsuri VALUES (4,30,500);
  335. INSERT INTO raspunsuri VALUES (7,31,500);
  336. INSERT INTO raspunsuri VALUES (6,32,500);
  337. INSERT INTO raspunsuri VALUES (6,33,500);
  338. INSERT INTO raspunsuri VALUES (5,34,500);
  339. INSERT INTO raspunsuri VALUES (4,35,500);
  340. INSERT INTO raspunsuri VALUES (1,36,500);
  341. INSERT INTO raspunsuri VALUES (7,37,500);
  342. INSERT INTO raspunsuri VALUES (1,38,500);
  343. INSERT INTO raspunsuri VALUES (3,39,500);
  344. INSERT INTO raspunsuri VALUES (1,40,500);
  345. INSERT INTO raspunsuri VALUES (5,41,500);
  346. INSERT INTO raspunsuri VALUES (1,42,500);
  347. INSERT INTO raspunsuri VALUES (4,43,500);
  348. INSERT INTO raspunsuri VALUES (2,44,500);
  349. INSERT INTO raspunsuri VALUES (6,45,500);
  350. INSERT INTO raspunsuri VALUES (6,1,501);
  351. INSERT INTO raspunsuri VALUES (6,2,501);
  352. INSERT INTO raspunsuri VALUES (6,3,501);
  353. INSERT INTO raspunsuri VALUES (6,4,501);
  354. INSERT INTO raspunsuri VALUES (3,5,501);
  355. INSERT INTO raspunsuri VALUES (4,6,501);
  356. INSERT INTO raspunsuri VALUES (6,7,501);
  357. INSERT INTO raspunsuri VALUES (5,8,501);
  358. INSERT INTO raspunsuri VALUES (4,9,501);
  359. INSERT INTO raspunsuri VALUES (1,10,501);
  360. INSERT INTO raspunsuri VALUES (2,11,501);
  361. INSERT INTO raspunsuri VALUES (4,12,501);
  362. INSERT INTO raspunsuri VALUES (1,13,501);
  363. INSERT INTO raspunsuri VALUES (6,14,501);
  364. INSERT INTO raspunsuri VALUES (5,15,501);
  365. INSERT INTO raspunsuri VALUES (6,16,501);
  366. INSERT INTO raspunsuri VALUES (6,17,501);
  367. INSERT INTO raspunsuri VALUES (1,18,501);
  368. INSERT INTO raspunsuri VALUES (7,19,501);
  369. INSERT INTO raspunsuri VALUES (7,20,501);
  370. INSERT INTO raspunsuri VALUES (3,21,501);
  371. INSERT INTO raspunsuri VALUES (7,22,501);
  372. INSERT INTO raspunsuri VALUES (2,23,501);
  373. INSERT INTO raspunsuri VALUES (1,24,501);
  374. INSERT INTO raspunsuri VALUES (6,25,501);
  375. INSERT INTO raspunsuri VALUES (4,26,501);
  376. INSERT INTO raspunsuri VALUES (1,27,501);
  377. INSERT INTO raspunsuri VALUES (1,28,501);
  378. INSERT INTO raspunsuri VALUES (4,29,501);
  379. INSERT INTO raspunsuri VALUES (7,30,501);
  380. INSERT INTO raspunsuri VALUES (2,31,501);
  381. INSERT INTO raspunsuri VALUES (3,32,501);
  382. INSERT INTO raspunsuri VALUES (5,33,501);
  383. INSERT INTO raspunsuri VALUES (3,34,501);
  384. INSERT INTO raspunsuri VALUES (1,35,501);
  385. INSERT INTO raspunsuri VALUES (6,36,501);
  386. INSERT INTO raspunsuri VALUES (3,37,501);
  387. INSERT INTO raspunsuri VALUES (1,38,501);
  388. INSERT INTO raspunsuri VALUES (6,39,501);
  389. INSERT INTO raspunsuri VALUES (5,40,501);
  390. INSERT INTO raspunsuri VALUES (4,41,501);
  391. INSERT INTO raspunsuri VALUES (7,42,501);
  392. INSERT INTO raspunsuri VALUES (5,43,501);
  393. INSERT INTO raspunsuri VALUES (1,44,501);
  394. INSERT INTO raspunsuri VALUES (6,45,501);
  395. INSERT INTO raspunsuri VALUES (1,1,502);
  396. INSERT INTO raspunsuri VALUES (6,2,502);
  397. INSERT INTO raspunsuri VALUES (1,3,502);
  398. INSERT INTO raspunsuri VALUES (1,4,502);
  399. INSERT INTO raspunsuri VALUES (2,5,502);
  400. INSERT INTO raspunsuri VALUES (6,6,502);
  401. INSERT INTO raspunsuri VALUES (1,7,502);
  402. INSERT INTO raspunsuri VALUES (6,8,502);
  403. INSERT INTO raspunsuri VALUES (5,9,502);
  404. INSERT INTO raspunsuri VALUES (3,10,502);
  405. INSERT INTO raspunsuri VALUES (6,11,502);
  406. INSERT INTO raspunsuri VALUES (5,12,502);
  407. INSERT INTO raspunsuri VALUES (4,13,502);
  408. INSERT INTO raspunsuri VALUES (6,14,502);
  409. INSERT INTO raspunsuri VALUES (5,15,502);
  410. INSERT INTO raspunsuri VALUES (4,16,502);
  411. INSERT INTO raspunsuri VALUES (1,17,502);
  412. INSERT INTO raspunsuri VALUES (3,18,502);
  413. INSERT INTO raspunsuri VALUES (3,19,502);
  414. INSERT INTO raspunsuri VALUES (2,20,502);
  415. INSERT INTO raspunsuri VALUES (3,21,502);
  416. INSERT INTO raspunsuri VALUES (6,22,502);
  417. INSERT INTO raspunsuri VALUES (4,23,502);
  418. INSERT INTO raspunsuri VALUES (2,24,502);
  419. INSERT INTO raspunsuri VALUES (1,25,502);
  420. INSERT INTO raspunsuri VALUES (3,26,502);
  421. INSERT INTO raspunsuri VALUES (2,27,502);
  422. INSERT INTO raspunsuri VALUES (6,28,502);
  423. INSERT INTO raspunsuri VALUES (5,29,502);
  424. INSERT INTO raspunsuri VALUES (3,30,502);
  425. INSERT INTO raspunsuri VALUES (4,31,502);
  426. INSERT INTO raspunsuri VALUES (5,32,502);
  427. INSERT INTO raspunsuri VALUES (7,33,502);
  428. INSERT INTO raspunsuri VALUES (1,34,502);
  429. INSERT INTO raspunsuri VALUES (3,35,502);
  430. INSERT INTO raspunsuri VALUES (5,36,502);
  431. INSERT INTO raspunsuri VALUES (4,37,502);
  432. INSERT INTO raspunsuri VALUES (4,38,502);
  433. INSERT INTO raspunsuri VALUES (5,39,502);
  434. INSERT INTO raspunsuri VALUES (1,40,502);
  435. INSERT INTO raspunsuri VALUES (1,41,502);
  436. INSERT INTO raspunsuri VALUES (2,42,502);
  437. INSERT INTO raspunsuri VALUES (6,43,502);
  438. INSERT INTO raspunsuri VALUES (7,44,502);
  439. INSERT INTO raspunsuri VALUES (7,45,502);
  440. INSERT INTO raspunsuri VALUES (3,1,503);
  441. INSERT INTO raspunsuri VALUES (7,2,503);
  442. INSERT INTO raspunsuri VALUES (4,3,503);
  443. INSERT INTO raspunsuri VALUES (2,4,503);
  444. INSERT INTO raspunsuri VALUES (4,5,503);
  445. INSERT INTO raspunsuri VALUES (1,6,503);
  446. INSERT INTO raspunsuri VALUES (6,7,503);
  447. INSERT INTO raspunsuri VALUES (3,8,503);
  448. INSERT INTO raspunsuri VALUES (6,9,503);
  449. INSERT INTO raspunsuri VALUES (5,10,503);
  450. INSERT INTO raspunsuri VALUES (1,11,503);
  451. INSERT INTO raspunsuri VALUES (1,12,503);
  452. INSERT INTO raspunsuri VALUES (7,13,503);
  453. INSERT INTO raspunsuri VALUES (4,14,503);
  454. INSERT INTO raspunsuri VALUES (4,15,503);
  455. INSERT INTO raspunsuri VALUES (2,16,503);
  456. INSERT INTO raspunsuri VALUES (3,17,503);
  457. INSERT INTO raspunsuri VALUES (1,18,503);
  458. INSERT INTO raspunsuri VALUES (6,19,503);
  459. INSERT INTO raspunsuri VALUES (4,20,503);
  460. INSERT INTO raspunsuri VALUES (3,21,503);
  461. INSERT INTO raspunsuri VALUES (1,22,503);
  462. INSERT INTO raspunsuri VALUES (7,23,503);
  463. INSERT INTO raspunsuri VALUES (1,24,503);
  464. INSERT INTO raspunsuri VALUES (2,25,503);
  465. INSERT INTO raspunsuri VALUES (3,26,503);
  466. INSERT INTO raspunsuri VALUES (4,27,503);
  467. INSERT INTO raspunsuri VALUES (4,28,503);
  468. INSERT INTO raspunsuri VALUES (5,29,503);
  469. INSERT INTO raspunsuri VALUES (4,30,503);
  470. INSERT INTO raspunsuri VALUES (2,31,503);
  471. INSERT INTO raspunsuri VALUES (4,32,503);
  472. INSERT INTO raspunsuri VALUES (1,33,503);
  473. INSERT INTO raspunsuri VALUES (6,34,503);
  474. INSERT INTO raspunsuri VALUES (4,35,503);
  475. INSERT INTO raspunsuri VALUES (1,36,503);
  476. INSERT INTO raspunsuri VALUES (7,37,503);
  477. INSERT INTO raspunsuri VALUES (3,38,503);
  478. INSERT INTO raspunsuri VALUES (1,39,503);
  479. INSERT INTO raspunsuri VALUES (7,40,503);
  480. INSERT INTO raspunsuri VALUES (2,41,503);
  481. INSERT INTO raspunsuri VALUES (7,42,503);
  482. INSERT INTO raspunsuri VALUES (3,43,503);
  483. INSERT INTO raspunsuri VALUES (6,44,503);
  484. INSERT INTO raspunsuri VALUES (2,45,503);
  485. INSERT INTO raspunsuri VALUES (5,1,504);
  486. INSERT INTO raspunsuri VALUES (4,2,504);
  487. INSERT INTO raspunsuri VALUES (1,3,504);
  488. INSERT INTO raspunsuri VALUES (3,4,504);
  489. INSERT INTO raspunsuri VALUES (6,5,504);
  490. INSERT INTO raspunsuri VALUES (3,6,504);
  491. INSERT INTO raspunsuri VALUES (7,7,504);
  492. INSERT INTO raspunsuri VALUES (3,8,504);
  493. INSERT INTO raspunsuri VALUES (7,9,504);
  494. INSERT INTO raspunsuri VALUES (5,10,504);
  495. INSERT INTO raspunsuri VALUES (5,11,504);
  496. INSERT INTO raspunsuri VALUES (5,12,504);
  497. INSERT INTO raspunsuri VALUES (1,13,504);
  498. INSERT INTO raspunsuri VALUES (3,14,504);
  499. INSERT INTO raspunsuri VALUES (2,15,504);
  500. INSERT INTO raspunsuri VALUES (6,16,504);
  501. INSERT INTO raspunsuri VALUES (2,17,504);
  502. INSERT INTO raspunsuri VALUES (1,18,504);
  503. INSERT INTO raspunsuri VALUES (5,19,504);
  504. INSERT INTO raspunsuri VALUES (6,20,504);
  505. INSERT INTO raspunsuri VALUES (6,21,504);
  506. INSERT INTO raspunsuri VALUES (2,22,504);
  507. INSERT INTO raspunsuri VALUES (5,23,504);
  508. INSERT INTO raspunsuri VALUES (2,24,504);
  509. INSERT INTO raspunsuri VALUES (6,25,504);
  510. INSERT INTO raspunsuri VALUES (5,26,504);
  511. INSERT INTO raspunsuri VALUES (1,27,504);
  512. INSERT INTO raspunsuri VALUES (5,28,504);
  513. INSERT INTO raspunsuri VALUES (5,29,504);
  514. INSERT INTO raspunsuri VALUES (7,30,504);
  515. INSERT INTO raspunsuri VALUES (2,31,504);
  516. INSERT INTO raspunsuri VALUES (6,32,504);
  517. INSERT INTO raspunsuri VALUES (3,33,504);
  518. INSERT INTO raspunsuri VALUES (6,34,504);
  519. INSERT INTO raspunsuri VALUES (7,35,504);
  520. INSERT INTO raspunsuri VALUES (7,36,504);
  521. INSERT INTO raspunsuri VALUES (4,37,504);
  522. INSERT INTO raspunsuri VALUES (4,38,504);
  523. INSERT INTO raspunsuri VALUES (7,39,504);
  524. INSERT INTO raspunsuri VALUES (6,40,504);
  525. INSERT INTO raspunsuri VALUES (5,41,504);
  526. INSERT INTO raspunsuri VALUES (2,42,504);
  527. INSERT INTO raspunsuri VALUES (1,43,504);
  528. INSERT INTO raspunsuri VALUES (6,44,504);
  529. INSERT INTO raspunsuri VALUES (5,45,504);
  530. INSERT INTO raspunsuri VALUES (2,1,505);
  531. INSERT INTO raspunsuri VALUES (6,2,505);
  532. INSERT INTO raspunsuri VALUES (4,3,505);
  533. INSERT INTO raspunsuri VALUES (7,4,505);
  534. INSERT INTO raspunsuri VALUES (4,5,505);
  535. INSERT INTO raspunsuri VALUES (4,6,505);
  536. INSERT INTO raspunsuri VALUES (7,7,505);
  537. INSERT INTO raspunsuri VALUES (7,8,505);
  538. INSERT INTO raspunsuri VALUES (3,9,505);
  539. INSERT INTO raspunsuri VALUES (3,10,505);
  540. INSERT INTO raspunsuri VALUES (7,11,505);
  541. INSERT INTO raspunsuri VALUES (3,12,505);
  542. INSERT INTO raspunsuri VALUES (1,13,505);
  543. INSERT INTO raspunsuri VALUES (5,14,505);
  544. INSERT INTO raspunsuri VALUES (3,15,505);
  545. INSERT INTO raspunsuri VALUES (2,16,505);
  546. INSERT INTO raspunsuri VALUES (1,17,505);
  547. INSERT INTO raspunsuri VALUES (3,18,505);
  548. INSERT INTO raspunsuri VALUES (5,19,505);
  549. INSERT INTO raspunsuri VALUES (3,20,505);
  550. INSERT INTO raspunsuri VALUES (1,21,505);
  551. INSERT INTO raspunsuri VALUES (5,22,505);
  552. INSERT INTO raspunsuri VALUES (1,23,505);
  553. INSERT INTO raspunsuri VALUES (4,24,505);
  554. INSERT INTO raspunsuri VALUES (7,25,505);
  555. INSERT INTO raspunsuri VALUES (1,26,505);
  556. INSERT INTO raspunsuri VALUES (6,27,505);
  557. INSERT INTO raspunsuri VALUES (1,28,505);
  558. INSERT INTO raspunsuri VALUES (5,29,505);
  559. INSERT INTO raspunsuri VALUES (7,30,505);
  560. INSERT INTO raspunsuri VALUES (2,31,505);
  561. INSERT INTO raspunsuri VALUES (2,32,505);
  562. INSERT INTO raspunsuri VALUES (1,33,505);
  563. INSERT INTO raspunsuri VALUES (5,34,505);
  564. INSERT INTO raspunsuri VALUES (4,35,505);
  565. INSERT INTO raspunsuri VALUES (5,36,505);
  566. INSERT INTO raspunsuri VALUES (6,37,505);
  567. INSERT INTO raspunsuri VALUES (7,38,505);
  568. INSERT INTO raspunsuri VALUES (5,39,505);
  569. INSERT INTO raspunsuri VALUES (4,40,505);
  570. INSERT INTO raspunsuri VALUES (4,41,505);
  571. INSERT INTO raspunsuri VALUES (1,42,505);
  572. INSERT INTO raspunsuri VALUES (6,43,505);
  573. INSERT INTO raspunsuri VALUES (1,44,505);
  574. INSERT INTO raspunsuri VALUES (6,45,505);
  575. INSERT INTO raspunsuri VALUES (7,1,506);
  576. INSERT INTO raspunsuri VALUES (5,2,506);
  577. INSERT INTO raspunsuri VALUES (5,3,506);
  578. INSERT INTO raspunsuri VALUES (7,4,506);
  579. INSERT INTO raspunsuri VALUES (5,5,506);
  580. INSERT INTO raspunsuri VALUES (6,6,506);
  581. INSERT INTO raspunsuri VALUES (5,7,506);
  582. INSERT INTO raspunsuri VALUES (3,8,506);
  583. INSERT INTO raspunsuri VALUES (7,9,506);
  584. INSERT INTO raspunsuri VALUES (5,10,506);
  585. INSERT INTO raspunsuri VALUES (1,11,506);
  586. INSERT INTO raspunsuri VALUES (6,12,506);
  587. INSERT INTO raspunsuri VALUES (7,13,506);
  588. INSERT INTO raspunsuri VALUES (7,14,506);
  589. INSERT INTO raspunsuri VALUES (3,15,506);
  590. INSERT INTO raspunsuri VALUES (1,16,506);
  591. INSERT INTO raspunsuri VALUES (1,17,506);
  592. INSERT INTO raspunsuri VALUES (6,18,506);
  593. INSERT INTO raspunsuri VALUES (2,19,506);
  594. INSERT INTO raspunsuri VALUES (1,20,506);
  595. INSERT INTO raspunsuri VALUES (6,21,506);
  596. INSERT INTO raspunsuri VALUES (2,22,506);
  597. INSERT INTO raspunsuri VALUES (4,23,506);
  598. INSERT INTO raspunsuri VALUES (6,24,506);
  599. INSERT INTO raspunsuri VALUES (4,25,506);
  600. INSERT INTO raspunsuri VALUES (5,26,506);
  601. INSERT INTO raspunsuri VALUES (1,27,506);
  602. INSERT INTO raspunsuri VALUES (1,28,506);
  603. INSERT INTO raspunsuri VALUES (5,29,506);
  604. INSERT INTO raspunsuri VALUES (7,30,506);
  605. INSERT INTO raspunsuri VALUES (7,31,506);
  606. INSERT INTO raspunsuri VALUES (3,32,506);
  607. INSERT INTO raspunsuri VALUES (4,33,506);
  608. INSERT INTO raspunsuri VALUES (1,34,506);
  609. INSERT INTO raspunsuri VALUES (3,35,506);
  610. INSERT INTO raspunsuri VALUES (4,36,506);
  611. INSERT INTO raspunsuri VALUES (7,37,506);
  612. INSERT INTO raspunsuri VALUES (5,38,506);
  613. INSERT INTO raspunsuri VALUES (7,39,506);
  614. INSERT INTO raspunsuri VALUES (6,40,506);
  615. INSERT INTO raspunsuri VALUES (6,41,506);
  616. INSERT INTO raspunsuri VALUES (2,42,506);
  617. INSERT INTO raspunsuri VALUES (5,43,506);
  618. INSERT INTO raspunsuri VALUES (6,44,506);
  619. INSERT INTO raspunsuri VALUES (3,45,506);
  620. INSERT INTO raspunsuri VALUES (6,1,507);
  621. INSERT INTO raspunsuri VALUES (1,2,507);
  622. INSERT INTO raspunsuri VALUES (7,3,507);
  623. INSERT INTO raspunsuri VALUES (6,4,507);
  624. INSERT INTO raspunsuri VALUES (4,5,507);
  625. INSERT INTO raspunsuri VALUES (5,6,507);
  626. INSERT INTO raspunsuri VALUES (7,7,507);
  627. INSERT INTO raspunsuri VALUES (6,8,507);
  628. INSERT INTO raspunsuri VALUES (1,9,507);
  629. INSERT INTO raspunsuri VALUES (4,10,507);
  630. INSERT INTO raspunsuri VALUES (4,11,507);
  631. INSERT INTO raspunsuri VALUES (2,12,507);
  632. INSERT INTO raspunsuri VALUES (7,13,507);
  633. INSERT INTO raspunsuri VALUES (4,14,507);
  634. INSERT INTO raspunsuri VALUES (3,15,507);
  635. INSERT INTO raspunsuri VALUES (5,16,507);
  636. INSERT INTO raspunsuri VALUES (6,17,507);
  637. INSERT INTO raspunsuri VALUES (4,18,507);
  638. INSERT INTO raspunsuri VALUES (5,19,507);
  639. INSERT INTO raspunsuri VALUES (7,20,507);
  640. INSERT INTO raspunsuri VALUES (3,21,507);
  641. INSERT INTO raspunsuri VALUES (2,22,507);
  642. INSERT INTO raspunsuri VALUES (6,23,507);
  643. INSERT INTO raspunsuri VALUES (5,24,507);
  644. INSERT INTO raspunsuri VALUES (7,25,507);
  645. INSERT INTO raspunsuri VALUES (2,26,507);
  646. INSERT INTO raspunsuri VALUES (2,27,507);
  647. INSERT INTO raspunsuri VALUES (7,28,507);
  648. INSERT INTO raspunsuri VALUES (4,29,507);
  649. INSERT INTO raspunsuri VALUES (3,30,507);
  650. INSERT INTO raspunsuri VALUES (1,31,507);
  651. INSERT INTO raspunsuri VALUES (1,32,507);
  652. INSERT INTO raspunsuri VALUES (2,33,507);
  653. INSERT INTO raspunsuri VALUES (6,34,507);
  654. INSERT INTO raspunsuri VALUES (7,35,507);
  655. INSERT INTO raspunsuri VALUES (6,36,507);
  656. INSERT INTO raspunsuri VALUES (7,37,507);
  657. INSERT INTO raspunsuri VALUES (7,38,507);
  658. INSERT INTO raspunsuri VALUES (7,39,507);
  659. INSERT INTO raspunsuri VALUES (5,40,507);
  660. INSERT INTO raspunsuri VALUES (7,41,507);
  661. INSERT INTO raspunsuri VALUES (2,42,507);
  662. INSERT INTO raspunsuri VALUES (4,43,507);
  663. INSERT INTO raspunsuri VALUES (7,44,507);
  664. INSERT INTO raspunsuri VALUES (1,45,507);
  665. INSERT INTO raspunsuri VALUES (5,1,508);
  666. INSERT INTO raspunsuri VALUES (5,2,508);
  667. INSERT INTO raspunsuri VALUES (5,3,508);
  668. INSERT INTO raspunsuri VALUES (3,4,508);
  669. INSERT INTO raspunsuri VALUES (2,5,508);
  670. INSERT INTO raspunsuri VALUES (3,6,508);
  671. INSERT INTO raspunsuri VALUES (3,7,508);
  672. INSERT INTO raspunsuri VALUES (6,8,508);
  673. INSERT INTO raspunsuri VALUES (2,9,508);
  674. INSERT INTO raspunsuri VALUES (4,10,508);
  675. INSERT INTO raspunsuri VALUES (5,11,508);
  676. INSERT INTO raspunsuri VALUES (3,12,508);
  677. INSERT INTO raspunsuri VALUES (7,13,508);
  678. INSERT INTO raspunsuri VALUES (5,14,508);
  679. INSERT INTO raspunsuri VALUES (5,15,508);
  680. INSERT INTO raspunsuri VALUES (1,16,508);
  681. INSERT INTO raspunsuri VALUES (4,17,508);
  682. INSERT INTO raspunsuri VALUES (7,18,508);
  683. INSERT INTO raspunsuri VALUES (4,19,508);
  684. INSERT INTO raspunsuri VALUES (3,20,508);
  685. INSERT INTO raspunsuri VALUES (5,21,508);
  686. INSERT INTO raspunsuri VALUES (7,22,508);
  687. INSERT INTO raspunsuri VALUES (4,23,508);
  688. INSERT INTO raspunsuri VALUES (7,24,508);
  689. INSERT INTO raspunsuri VALUES (4,25,508);
  690. INSERT INTO raspunsuri VALUES (6,26,508);
  691. INSERT INTO raspunsuri VALUES (5,27,508);
  692. INSERT INTO raspunsuri VALUES (3,28,508);
  693. INSERT INTO raspunsuri VALUES (7,29,508);
  694. INSERT INTO raspunsuri VALUES (7,30,508);
  695. INSERT INTO raspunsuri VALUES (7,31,508);
  696. INSERT INTO raspunsuri VALUES (3,32,508);
  697. INSERT INTO raspunsuri VALUES (7,33,508);
  698. INSERT INTO raspunsuri VALUES (4,34,508);
  699. INSERT INTO raspunsuri VALUES (2,35,508);
  700. INSERT INTO raspunsuri VALUES (3,36,508);
  701. INSERT INTO raspunsuri VALUES (7,37,508);
  702. INSERT INTO raspunsuri VALUES (4,38,508);
  703. INSERT INTO raspunsuri VALUES (7,39,508);
  704. INSERT INTO raspunsuri VALUES (2,40,508);
  705. INSERT INTO raspunsuri VALUES (7,41,508);
  706. INSERT INTO raspunsuri VALUES (1,42,508);
  707. INSERT INTO raspunsuri VALUES (1,43,508);
  708. INSERT INTO raspunsuri VALUES (6,44,508);
  709. INSERT INTO raspunsuri VALUES (1,45,508);
  710. INSERT INTO raspunsuri VALUES (1,1,509);
  711. INSERT INTO raspunsuri VALUES (3,2,509);
  712. INSERT INTO raspunsuri VALUES (5,3,509);
  713. INSERT INTO raspunsuri VALUES (7,4,509);
  714. INSERT INTO raspunsuri VALUES (2,5,509);
  715. INSERT INTO raspunsuri VALUES (6,6,509);
  716. INSERT INTO raspunsuri VALUES (5,7,509);
  717. INSERT INTO raspunsuri VALUES (2,8,509);
  718. INSERT INTO raspunsuri VALUES (5,9,509);
  719. INSERT INTO raspunsuri VALUES (2,10,509);
  720. INSERT INTO raspunsuri VALUES (4,11,509);
  721. INSERT INTO raspunsuri VALUES (2,12,509);
  722. INSERT INTO raspunsuri VALUES (4,13,509);
  723. INSERT INTO raspunsuri VALUES (7,14,509);
  724. INSERT INTO raspunsuri VALUES (3,15,509);
  725. INSERT INTO raspunsuri VALUES (1,16,509);
  726. INSERT INTO raspunsuri VALUES (4,17,509);
  727. INSERT INTO raspunsuri VALUES (2,18,509);
  728. INSERT INTO raspunsuri VALUES (6,19,509);
  729. INSERT INTO raspunsuri VALUES (3,20,509);
  730. INSERT INTO raspunsuri VALUES (4,21,509);
  731. INSERT INTO raspunsuri VALUES (5,22,509);
  732. INSERT INTO raspunsuri VALUES (4,23,509);
  733. INSERT INTO raspunsuri VALUES (4,24,509);
  734. INSERT INTO raspunsuri VALUES (5,25,509);
  735. INSERT INTO raspunsuri VALUES (7,26,509);
  736. INSERT INTO raspunsuri VALUES (3,27,509);
  737. INSERT INTO raspunsuri VALUES (2,28,509);
  738. INSERT INTO raspunsuri VALUES (1,29,509);
  739. INSERT INTO raspunsuri VALUES (3,30,509);
  740. INSERT INTO raspunsuri VALUES (7,31,509);
  741. INSERT INTO raspunsuri VALUES (5,32,509);
  742. INSERT INTO raspunsuri VALUES (7,33,509);
  743. INSERT INTO raspunsuri VALUES (6,34,509);
  744. INSERT INTO raspunsuri VALUES (6,35,509);
  745. INSERT INTO raspunsuri VALUES (3,36,509);
  746. INSERT INTO raspunsuri VALUES (7,37,509);
  747. INSERT INTO raspunsuri VALUES (6,38,509);
  748. INSERT INTO raspunsuri VALUES (7,39,509);
  749. INSERT INTO raspunsuri VALUES (1,40,509);
  750. INSERT INTO raspunsuri VALUES (1,41,509);
  751. INSERT INTO raspunsuri VALUES (2,42,509);
  752. INSERT INTO raspunsuri VALUES (7,43,509);
  753. INSERT INTO raspunsuri VALUES (5,44,509);
  754. INSERT INTO raspunsuri VALUES (6,45,509);
  755. INSERT INTO raspunsuri VALUES (3,1,510);
  756. INSERT INTO raspunsuri VALUES (5,2,510);
  757. INSERT INTO raspunsuri VALUES (7,3,510);
  758. INSERT INTO raspunsuri VALUES (1,4,510);
  759. INSERT INTO raspunsuri VALUES (5,5,510);
  760. INSERT INTO raspunsuri VALUES (6,6,510);
  761. INSERT INTO raspunsuri VALUES (3,7,510);
  762. INSERT INTO raspunsuri VALUES (7,8,510);
  763. INSERT INTO raspunsuri VALUES (7,9,510);
  764. INSERT INTO raspunsuri VALUES (7,10,510);
  765. INSERT INTO raspunsuri VALUES (2,11,510);
  766. INSERT INTO raspunsuri VALUES (1,12,510);
  767. INSERT INTO raspunsuri VALUES (7,13,510);
  768. INSERT INTO raspunsuri VALUES (7,14,510);
  769. INSERT INTO raspunsuri VALUES (6,15,510);
  770. INSERT INTO raspunsuri VALUES (4,16,510);
  771. INSERT INTO raspunsuri VALUES (1,17,510);
  772. INSERT INTO raspunsuri VALUES (5,18,510);
  773. INSERT INTO raspunsuri VALUES (2,19,510);
  774. INSERT INTO raspunsuri VALUES (6,20,510);
  775. INSERT INTO raspunsuri VALUES (5,21,510);
  776. INSERT INTO raspunsuri VALUES (1,22,510);
  777. INSERT INTO raspunsuri VALUES (6,23,510);
  778. INSERT INTO raspunsuri VALUES (1,24,510);
  779. INSERT INTO raspunsuri VALUES (6,25,510);
  780. INSERT INTO raspunsuri VALUES (6,26,510);
  781. INSERT INTO raspunsuri VALUES (2,27,510);
  782. INSERT INTO raspunsuri VALUES (5,28,510);
  783. INSERT INTO raspunsuri VALUES (5,29,510);
  784. INSERT INTO raspunsuri VALUES (3,30,510);
  785. INSERT INTO raspunsuri VALUES (5,31,510);
  786. INSERT INTO raspunsuri VALUES (4,32,510);
  787. INSERT INTO raspunsuri VALUES (4,33,510);
  788. INSERT INTO raspunsuri VALUES (3,34,510);
  789. INSERT INTO raspunsuri VALUES (6,35,510);
  790. INSERT INTO raspunsuri VALUES (1,36,510);
  791. INSERT INTO raspunsuri VALUES (1,37,510);
  792. INSERT INTO raspunsuri VALUES (1,38,510);
  793. INSERT INTO raspunsuri VALUES (4,39,510);
  794. INSERT INTO raspunsuri VALUES (7,40,510);
  795. INSERT INTO raspunsuri VALUES (3,41,510);
  796. INSERT INTO raspunsuri VALUES (2,42,510);
  797. INSERT INTO raspunsuri VALUES (6,43,510);
  798. INSERT INTO raspunsuri VALUES (4,44,510);
  799. INSERT INTO raspunsuri VALUES (5,45,510);
  800. INSERT INTO raspunsuri VALUES (6,1,511);
  801. INSERT INTO raspunsuri VALUES (4,2,511);
  802. INSERT INTO raspunsuri VALUES (7,3,511);
  803. INSERT INTO raspunsuri VALUES (6,4,511);
  804. INSERT INTO raspunsuri VALUES (5,5,511);
  805. INSERT INTO raspunsuri VALUES (5,6,511);
  806. INSERT INTO raspunsuri VALUES (1,7,511);
  807. INSERT INTO raspunsuri VALUES (1,8,511);
  808. INSERT INTO raspunsuri VALUES (3,9,511);
  809. INSERT INTO raspunsuri VALUES (1,10,511);
  810. INSERT INTO raspunsuri VALUES (5,11,511);
  811. INSERT INTO raspunsuri VALUES (3,12,511);
  812. INSERT INTO raspunsuri VALUES (6,13,511);
  813. INSERT INTO raspunsuri VALUES (2,14,511);
  814. INSERT INTO raspunsuri VALUES (2,15,511);
  815. INSERT INTO raspunsuri VALUES (5,16,511);
  816. INSERT INTO raspunsuri VALUES (2,17,511);
  817. INSERT INTO raspunsuri VALUES (1,18,511);
  818. INSERT INTO raspunsuri VALUES (5,19,511);
  819. INSERT INTO raspunsuri VALUES (3,20,511);
  820. INSERT INTO raspunsuri VALUES (3,21,511);
  821. INSERT INTO raspunsuri VALUES (5,22,511);
  822. INSERT INTO raspunsuri VALUES (4,23,511);
  823. INSERT INTO raspunsuri VALUES (3,24,511);
  824. INSERT INTO raspunsuri VALUES (2,25,511);
  825. INSERT INTO raspunsuri VALUES (6,26,511);
  826. INSERT INTO raspunsuri VALUES (3,27,511);
  827. INSERT INTO raspunsuri VALUES (3,28,511);
  828. INSERT INTO raspunsuri VALUES (5,29,511);
  829. INSERT INTO raspunsuri VALUES (7,30,511);
  830. INSERT INTO raspunsuri VALUES (5,31,511);
  831. INSERT INTO raspunsuri VALUES (7,32,511);
  832. INSERT INTO raspunsuri VALUES (6,33,511);
  833. INSERT INTO raspunsuri VALUES (5,34,511);
  834. INSERT INTO raspunsuri VALUES (1,35,511);
  835. INSERT INTO raspunsuri VALUES (3,36,511);
  836. INSERT INTO raspunsuri VALUES (3,37,511);
  837. INSERT INTO raspunsuri VALUES (6,38,511);
  838. INSERT INTO raspunsuri VALUES (3,39,511);
  839. INSERT INTO raspunsuri VALUES (5,40,511);
  840. INSERT INTO raspunsuri VALUES (5,41,511);
  841. INSERT INTO raspunsuri VALUES (6,42,511);
  842. INSERT INTO raspunsuri VALUES (1,43,511);
  843. INSERT INTO raspunsuri VALUES (1,44,511);
  844. INSERT INTO raspunsuri VALUES (3,45,511);
  845. INSERT INTO raspunsuri VALUES (1,1,512);
  846. INSERT INTO raspunsuri VALUES (3,2,512);
  847. INSERT INTO raspunsuri VALUES (4,3,512);
  848. INSERT INTO raspunsuri VALUES (6,4,512);
  849. INSERT INTO raspunsuri VALUES (1,5,512);
  850. INSERT INTO raspunsuri VALUES (1,6,512);
  851. INSERT INTO raspunsuri VALUES (5,7,512);
  852. INSERT INTO raspunsuri VALUES (2,8,512);
  853. INSERT INTO raspunsuri VALUES (5,9,512);
  854. INSERT INTO raspunsuri VALUES (4,10,512);
  855. INSERT INTO raspunsuri VALUES (5,11,512);
  856. INSERT INTO raspunsuri VALUES (3,12,512);
  857. INSERT INTO raspunsuri VALUES (3,13,512);
  858. INSERT INTO raspunsuri VALUES (7,14,512);
  859. INSERT INTO raspunsuri VALUES (3,15,512);
  860. INSERT INTO raspunsuri VALUES (4,16,512);
  861. INSERT INTO raspunsuri VALUES (3,17,512);
  862. INSERT INTO raspunsuri VALUES (2,18,512);
  863. INSERT INTO raspunsuri VALUES (5,19,512);
  864. INSERT INTO raspunsuri VALUES (7,20,512);
  865. INSERT INTO raspunsuri VALUES (6,21,512);
  866. INSERT INTO raspunsuri VALUES (4,22,512);
  867. INSERT INTO raspunsuri VALUES (7,23,512);
  868. INSERT INTO raspunsuri VALUES (1,24,512);
  869. INSERT INTO raspunsuri VALUES (1,25,512);
  870. INSERT INTO raspunsuri VALUES (7,26,512);
  871. INSERT INTO raspunsuri VALUES (1,27,512);
  872. INSERT INTO raspunsuri VALUES (7,28,512);
  873. INSERT INTO raspunsuri VALUES (6,29,512);
  874. INSERT INTO raspunsuri VALUES (7,30,512);
  875. INSERT INTO raspunsuri VALUES (2,31,512);
  876. INSERT INTO raspunsuri VALUES (1,32,512);
  877. INSERT INTO raspunsuri VALUES (1,33,512);
  878. INSERT INTO raspunsuri VALUES (3,34,512);
  879. INSERT INTO raspunsuri VALUES (6,35,512);
  880. INSERT INTO raspunsuri VALUES (7,36,512);
  881. INSERT INTO raspunsuri VALUES (7,37,512);
  882. INSERT INTO raspunsuri VALUES (6,38,512);
  883. INSERT INTO raspunsuri VALUES (2,39,512);
  884. INSERT INTO raspunsuri VALUES (5,40,512);
  885. INSERT INTO raspunsuri VALUES (3,41,512);
  886. INSERT INTO raspunsuri VALUES (6,42,512);
  887. INSERT INTO raspunsuri VALUES (3,43,512);
  888. INSERT INTO raspunsuri VALUES (1,44,512);
  889. INSERT INTO raspunsuri VALUES (6,45,512);
  890. INSERT INTO raspunsuri VALUES (5,1,513);
  891. INSERT INTO raspunsuri VALUES (4,2,513);
  892. INSERT INTO raspunsuri VALUES (1,3,513);
  893. INSERT INTO raspunsuri VALUES (5,4,513);
  894. INSERT INTO raspunsuri VALUES (7,5,513);
  895. INSERT INTO raspunsuri VALUES (3,6,513);
  896. INSERT INTO raspunsuri VALUES (4,7,513);
  897. INSERT INTO raspunsuri VALUES (5,8,513);
  898. INSERT INTO raspunsuri VALUES (5,9,513);
  899. INSERT INTO raspunsuri VALUES (5,10,513);
  900. INSERT INTO raspunsuri VALUES (1,11,513);
  901. INSERT INTO raspunsuri VALUES (6,12,513);
  902. INSERT INTO raspunsuri VALUES (1,13,513);
  903. INSERT INTO raspunsuri VALUES (3,14,513);
  904. INSERT INTO raspunsuri VALUES (1,15,513);
  905. INSERT INTO raspunsuri VALUES (3,16,513);
  906. INSERT INTO raspunsuri VALUES (2,17,513);
  907. INSERT INTO raspunsuri VALUES (6,18,513);
  908. INSERT INTO raspunsuri VALUES (4,19,513);
  909. INSERT INTO raspunsuri VALUES (1,20,513);
  910. INSERT INTO raspunsuri VALUES (5,21,513);
  911. INSERT INTO raspunsuri VALUES (7,22,513);
  912. INSERT INTO raspunsuri VALUES (2,23,513);
  913. INSERT INTO raspunsuri VALUES (4,24,513);
  914. INSERT INTO raspunsuri VALUES (3,25,513);
  915. INSERT INTO raspunsuri VALUES (4,26,513);
  916. INSERT INTO raspunsuri VALUES (3,27,513);
  917. INSERT INTO raspunsuri VALUES (3,28,513);
  918. INSERT INTO raspunsuri VALUES (2,29,513);
  919. INSERT INTO raspunsuri VALUES (7,30,513);
  920. INSERT INTO raspunsuri VALUES (3,31,513);
  921. INSERT INTO raspunsuri VALUES (4,32,513);
  922. INSERT INTO raspunsuri VALUES (6,33,513);
  923. INSERT INTO raspunsuri VALUES (3,34,513);
  924. INSERT INTO raspunsuri VALUES (6,35,513);
  925. INSERT INTO raspunsuri VALUES (6,36,513);
  926. INSERT INTO raspunsuri VALUES (7,37,513);
  927. INSERT INTO raspunsuri VALUES (2,38,513);
  928. INSERT INTO raspunsuri VALUES (2,39,513);
  929. INSERT INTO raspunsuri VALUES (1,40,513);
  930. INSERT INTO raspunsuri VALUES (3,41,513);
  931. INSERT INTO raspunsuri VALUES (1,42,513);
  932. INSERT INTO raspunsuri VALUES (3,43,513);
  933. INSERT INTO raspunsuri VALUES (3,44,513);
  934. INSERT INTO raspunsuri VALUES (1,45,513);
  935. INSERT INTO raspunsuri VALUES (7,1,514);
  936. INSERT INTO raspunsuri VALUES (5,2,514);
  937. INSERT INTO raspunsuri VALUES (4,3,514);
  938. INSERT INTO raspunsuri VALUES (1,4,514);
  939. INSERT INTO raspunsuri VALUES (2,5,514);
  940. INSERT INTO raspunsuri VALUES (3,6,514);
  941. INSERT INTO raspunsuri VALUES (5,7,514);
  942. INSERT INTO raspunsuri VALUES (3,8,514);
  943. INSERT INTO raspunsuri VALUES (3,9,514);
  944. INSERT INTO raspunsuri VALUES (6,10,514);
  945. INSERT INTO raspunsuri VALUES (5,11,514);
  946. INSERT INTO raspunsuri VALUES (1,12,514);
  947. INSERT INTO raspunsuri VALUES (4,13,514);
  948. INSERT INTO raspunsuri VALUES (4,14,514);
  949. INSERT INTO raspunsuri VALUES (3,15,514);
  950. INSERT INTO raspunsuri VALUES (4,16,514);
  951. INSERT INTO raspunsuri VALUES (6,17,514);
  952. INSERT INTO raspunsuri VALUES (2,18,514);
  953. INSERT INTO raspunsuri VALUES (2,19,514);
  954. INSERT INTO raspunsuri VALUES (1,20,514);
  955. INSERT INTO raspunsuri VALUES (6,21,514);
  956. INSERT INTO raspunsuri VALUES (2,22,514);
  957. INSERT INTO raspunsuri VALUES (2,23,514);
  958. INSERT INTO raspunsuri VALUES (5,24,514);
  959. INSERT INTO raspunsuri VALUES (2,25,514);
  960. INSERT INTO raspunsuri VALUES (2,26,514);
  961. INSERT INTO raspunsuri VALUES (4,27,514);
  962. INSERT INTO raspunsuri VALUES (2,28,514);
  963. INSERT INTO raspunsuri VALUES (5,29,514);
  964. INSERT INTO raspunsuri VALUES (2,30,514);
  965. INSERT INTO raspunsuri VALUES (7,31,514);
  966. INSERT INTO raspunsuri VALUES (6,32,514);
  967. INSERT INTO raspunsuri VALUES (2,33,514);
  968. INSERT INTO raspunsuri VALUES (6,34,514);
  969. INSERT INTO raspunsuri VALUES (6,35,514);
  970. INSERT INTO raspunsuri VALUES (3,36,514);
  971. INSERT INTO raspunsuri VALUES (5,37,514);
  972. INSERT INTO raspunsuri VALUES (1,38,514);
  973. INSERT INTO raspunsuri VALUES (7,39,514);
  974. INSERT INTO raspunsuri VALUES (3,40,514);
  975. INSERT INTO raspunsuri VALUES (4,41,514);
  976. INSERT INTO raspunsuri VALUES (6,42,514);
  977. INSERT INTO raspunsuri VALUES (5,43,514);
  978. INSERT INTO raspunsuri VALUES (4,44,514);
  979. INSERT INTO raspunsuri VALUES (7,45,514);
  980.  
  981.  
  982. -- LABORATOARE DATA
  983. INSERT INTO laboratoare VALUES (210);
  984. INSERT INTO laboratoare VALUES (211);
  985. INSERT INTO laboratoare VALUES (310);
  986.  
  987.  
  988. -- CALCULATOARE DATA
  989. INSERT INTO calculatoare VALUES (1,210);
  990. INSERT INTO calculatoare VALUES (2,210);
  991. INSERT INTO calculatoare VALUES (3,210);
  992. INSERT INTO calculatoare VALUES (4,210);
  993. INSERT INTO calculatoare VALUES (5,210);
  994. INSERT INTO calculatoare VALUES (6,210);
  995. INSERT INTO calculatoare VALUES (7,210);
  996. INSERT INTO calculatoare VALUES (8,210);
  997. INSERT INTO calculatoare VALUES (9,210);
  998. INSERT INTO calculatoare VALUES (10,210);
  999. INSERT INTO calculatoare VALUES (11,210);
  1000. INSERT INTO calculatoare VALUES (12,210);
  1001. INSERT INTO calculatoare VALUES (13,210);
  1002. INSERT INTO calculatoare VALUES (14,210);
  1003. INSERT INTO calculatoare VALUES (15,210);
  1004. INSERT INTO calculatoare VALUES (16,210);
  1005. INSERT INTO calculatoare VALUES (17,210);
  1006. INSERT INTO calculatoare VALUES (18,210);
  1007. INSERT INTO calculatoare VALUES (19,210);
  1008. INSERT INTO calculatoare VALUES (20,210);
  1009. INSERT INTO calculatoare VALUES (21,210);
  1010. INSERT INTO calculatoare VALUES (22,210);
  1011. INSERT INTO calculatoare VALUES (23,210);
  1012. INSERT INTO calculatoare VALUES (24,210);
  1013.  
  1014.  
  1015. -- EXPERIMENTE DATA
  1016. INSERT INTO experimente VALUES (10,'20-8-2017',211);
  1017. INSERT INTO experimente VALUES (11,'19-8-2017',210);
  1018. INSERT INTO experimente VALUES (12,'14-8-2017',211);
  1019. INSERT INTO experimente VALUES (13,'13-8-2017',211);
  1020. INSERT INTO experimente VALUES (14,'22-8-2017',210);
  1021. INSERT INTO experimente VALUES (15,'26-8-2017',211);
  1022. INSERT INTO experimente VALUES (16,'11-8-2017',310);
  1023. INSERT INTO experimente VALUES (17,'9-8-2017',210);
  1024.  
  1025.  
  1026. -- REZULTATE_EXPERIMENTE DATA
  1027. INSERT INTO rezultate_experimente VALUES (10,40,57,43,46,57,10,511);
  1028. INSERT INTO rezultate_experimente VALUES (11,78,56,17,52,34,10,509);
  1029. INSERT INTO rezultate_experimente VALUES (12,59,5,13,42,63,10,504);
  1030. INSERT INTO rezultate_experimente VALUES (13,9,96,69,93,64,11,507);
  1031. INSERT INTO rezultate_experimente VALUES (14,94,39,45,4,79,11,505);
  1032. INSERT INTO rezultate_experimente VALUES (15,84,78,63,42,24,11,506);
  1033. INSERT INTO rezultate_experimente VALUES (16,20,60,13,5,65,12,501);
  1034. INSERT INTO rezultate_experimente VALUES (17,31,58,71,77,69,12,503);
  1035.  
  1036.  
  1037. -- CERCETATORI DATA
  1038. INSERT INTO cercetatori VALUES (300,'PSIHOLOGIE CULTURALA','DOCTORAND',16,DEFAULT,12);
  1039. INSERT INTO cercetatori VALUES (301,'PSIHOLOGIE CULTURALA','DOCTORAND',15,DEFAULT,12);
  1040. INSERT INTO cercetatori VALUES (302,'BEHAVIORISM','CERCETATOR',14,DEFAULT,11);
  1041. INSERT INTO cercetatori VALUES (303,'PSIHOLOGIA PERSONALITATII','CERCETATOR',10,DEFAULT,10);
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!