-----------------------------------------------------populare baza de date---------------------------------------------------use Camin_studentesc;------------------------------------------------------------------------Studenti----------------------------------------------------------------------insert into Studenti(Nr_mat, Nr_etaj, Nr_camera, Nume)values('1','1','101','Tudor Ilie');insert into Studenti(Nr_mat, Nr_etaj, Nr_camera, Nume)values('2','1','102','Dumitru Gheorghe');insert into Studenti(Nr_mat, Nr_etaj, Nr_camera, Nume)values('3','2','206','Lungu Adrian');insert into Studenti(Nr_mat, Nr_etaj, Nr_camera, Nume)values('4','2','201','Vanturis ovidiu');insert into Studenti(Nr_mat, Nr_etaj, Nr_camera, Nume)values('5','2','210','Olteanu Marius');insert into Studenti(Nr_mat, Nr_etaj, Nr_camera, Nume)values('6','3','301','Sendroiu alina');insert into Studenti(Nr_mat, Nr_etaj, Nr_camera, Nume)values('7','3','304','Musca Stefan');insert into Studenti(Nr_mat, Nr_etaj, Nr_camera, Nume)values('8','4','404','Oprescu Bogdan');insert into Studenti(Nr_mat, Nr_etaj, Nr_camera, Nume)values('9','5','517','Popescu Ion');insert into Studenti(Nr_mat, Nr_etaj, Nr_camera, Nume)values('10','6','601','Ionescu Andrei');-------------------------------------------------------------------------Sef_de_camin-----------------------------------------------------------------------insert into Sef_de_camin(Nr_mat, Nr_etaj, Nr_camera,Nume,Nr_studenti,Nr_studenti_prezenri,Nr_chei,Fond_rulment,Fond_reparati,Alte_fonduri)values('1','1','101','Militie Alin','535','498','600','10000','78000','0')---------------------------------------------------------------------------------Sef_de_etaj-------------------------------------------------------------------------------insert into Sef_Etaj(Nr_mat,Nr_etaj,Nr_camera,Nume,Data_intrare_funct) values('14','2','205','Menchenie Catalin','2007-09-01');insert into Sef_Etaj(Nr_mat,Nr_etaj,Nr_camera,Nume,Data_intrare_funct) values('15','3','309','Dumitru Catalin','2007-09-01');insert into Sef_Etaj(Nr_mat,Nr_etaj,Nr_camera,Nume,Data_intrare_funct) values('18','4','415','Clenciu Alin','2007-09-01');---------------------------------------------------------------------------------Camin-------------------------------------------------------------------------------insert into Camin(Nr_camin,Nr_etaje,Nr_camere) values('10','9','800');---------------------------------------------------------------------------------Apartamente-------------------------------------------------------------------------------insert into Camere(Nr_camera, Nr_etaj, Nr_paturi, Nr_mese, Nr_scaune, Nr_prize_tv)values('102','1','5','5','5','2');insert into Camere(Nr_camera, Nr_etaj, Nr_paturi, Nr_mese, Nr_scaune, Nr_prize_tv)values('305','3','5','5','5','2');insert into Camere(Nr_camera, Nr_etaj, Nr_paturi, Nr_mese, Nr_scaune, Nr_prize_tv)values('309','3','5','5','5','1');insert into Camere(Nr_camera, Nr_etaj, Nr_paturi, Nr_mese, Nr_scaune, Nr_prize_tv)values('405','4','5','5','5','2');insert into Camere(Nr_camera, Nr_etaj, Nr_paturi, Nr_mese, Nr_scaune, Nr_prize_tv)values('607','6','5','5','5','2');insert into Camere(Nr_camera, Nr_etaj, Nr_paturi, Nr_mese, Nr_scaune, Nr_prize_tv)values('702','7','5','5','5','1');---------------------------------------------------------------------------------------------plati-------------------------------------------------------------------------------------------insert into plati(Data, Nr_mat, Valoare, Restanta) values('2007-06-02','1','300','0');insert into plati(Data, Nr_mat, Valoare, Restanta) values('2007-05-06','2','360','50');insert into plati(Data, Nr_mat, Valoare, Restanta) values('2007-07-02','3','500','500');insert into plati(Data, Nr_mat, Valoare, Restanta) values('2007-05-09','4','500','560');insert into plati(Data, Nr_mat, Valoare, Restanta) values('2007-08-02','5','600','300');insert into plati(Data, Nr_mat, Valoare, Restanta) values('2007-05-02','6','200','0');insert into plati(Data, Nr_mat, Valoare, Restanta) values('2007-01-03','9','400','0');insert into plati(Data, Nr_mat, Valoare, Restanta) values('2007-02-02','10','350','0');---------------------------------------------------------------------------------------------chitante-------------------------------------------------------------------------------------------insert into chitante(Nr_chit, Nr_mat, Valoare, Data) values('1','1','300','2006-01-02');insert into chitante(Nr_chit, Nr_mat, Valoare, Data) values('2','2','200','2006-01-03');insert into chitante(Nr_chit, Nr_mat, Valoare, Data) values('3','3','400','2006-01-07');insert into chitante(Nr_chit, Nr_mat, Valoare, Data) values('4','4','200','2006-01-09');insert into chitante(Nr_chit, Nr_mat, Valoare, Data) values('5','5','400','2006-01-06');insert into chitante(Nr_chit, Nr_mat, Valoare, Data) values('6','6','300','2006-01-02');insert into chitante(Nr_chit, Nr_mat, Valoare, Data) values('7','9','200','2006-01-05');insert into chitante(Nr_chit, Nr_mat, Valoare, Data) values('8','10','100','2006-01-12');----------------------------------------------------------------------------------------------furnizori--------------------------------------------------------------------------------------------insert into furnizori(Cod_furnizor, Denumire, Cod_fiscal, Cont, Banca, Strada, Nr, Bl, Sc, Ap, Localitate, Judet)values('1','Renel','1234','12345','Banc Post','Bucegi','1','3','1','2','Craiova','Dolj');insert into furnizori(Cod_furnizor, Denumire, Cod_fiscal, Cont, Banca, Strada, Nr, Bl, Sc, Ap, Localitate, Judet)values('2','Romgaz','1235','54321','BRD','Bucura','3','2','2','1','Craiova','Dolj');-----------------------------------------------------------------------------------------------cheltuieli---------------------------------------------------------------------------------------------insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('1','1','1','4','2006-02-12','3000');insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('2','1','2','3','2006-02-14','1000');insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('3','2','3','2','2006-03-12','2000');insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('4','2','4','1','2006-04-13','5000');insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('5','1','1','4','2006-02-12','300');insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('6','1','2','3','2006-02-14','100');insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('7','2','3','2','2006-03-12','200');insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('8','2','4','1','2006-04-13','500');insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('9','1','1','4','2006-02-12','300');insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('10','1','2','3','2006-02-14','100');insert into cheltuieli(Nr_crt, Cod_furnizor, Cod_cheltuiala, Nr_factura, Data_factura,Valoare_factura)values('11','2','3','2','2006-03-12','200');-----------------------------------------------personal-------------------------------------------------------------------------------------------------------insert into personal(Nr_matricol, Nume, Data_nasterii, Meseria, Data_angajarii)values('3','Simion Gheorghe','1967-05-01','instalator','2004-10-10');insert into personal(Nr_matricol, Nume, Data_nasterii, Meseria, Data_angajarii)values('4','Stancu Aurelia','1965','femeie de serviciu','2004-10-10');insert into personal(Nr_matricol, Nume, Data_nasterii, Meseria, Data_angajarii)values('1','Sima Ion','1966-05-02','instalator','2004-10-10');insert into personal(Nr_matricol, Nume, Data_nasterii, Meseria, Data_angajarii)values('2','Rotaru Ana','1961','femeie de serviciu','2004-10-10');--patrimoniu--------------------------------------------------------------------------------------------------------insert into patrimoniu(Nr_inventar, Nr_camin, Nr_etaj, Denumire, Inv_fix, Valoare) values('1','10','1','exctinctor','true','100');insert into patrimoniu(Nr_inventar, Nr_camin, Nr_etaj, Denumire, Inv_fix, Valoare) values('2','10','2','matura','false','10');insert into patrimoniu(Nr_inventar, Nr_camin, Nr_etaj, Denumire, Inv_fix, Valoare) values('3','10','2','extinctor','true','100');insert into patrimoniu(Nr_inventar, Nr_camin, Nr_etaj, Denumire, Inv_fix, Valoare) values('4','10','1','extinctor','true','100');----------------------------------------------------------------------------------------------------------achitari--------------------------------------------------------------------------------------------------------insert into achitari(Nr_crt, Nr_doc, Tip_op, Valoare_achit, Data) values('6','1','achit fact energ el','100','2006-03-14');insert into achitari(Nr_crt, Nr_doc, Tip_op, Valoare_achit, Data) values('7','2','achit fact gaze','200','2006-03-14');--------------------------------------------------------------------------------------------------------------------------