RelationalDesign: polnenje.sql

insert into Kategorii (tip) values 
        ('A'),
        ('A1'),
        ('B'),
        ('C'),
        ('C1'),
        ('D'),
        ('D1'),
        ('BE'),
        ('CE'),
        ('C1E'),
        ('DE'),
        ('D1E'),
        ('F'),
        ('G'),
        ('T');

--update izdavsaloni set imesal = 'Vehicle Rent LMK' where imesal = 'Veichal Rent LMK';
        

insert into  Vozila(idKat,model,marka,regTab,cenaVozi) values
  (5,'Arteon','Volkswagen','SK2200AB',6000),
  (5,'ID.4','Volkswagen','SK2568BA',7000),
  (5,'A4','Audi','SK2111AK',5500),
  (5,'Q2','Audi','SK3334OS',7500),
  (3,'Dandy 125','Jawa','SK7755AU',3500),
  (3,'GS 500 F','SUZUKI','SK9992AJ',5500),
  (3,'YZF-R1','Yamaha','SK2899BA',6500),
  (10,'SPRINTER','MERCEDES','SK1520UB',12000),
  (10,'TRANSIT CUSTOM','FORD','SK1525US',9000),
  (10,'Daily 3.0 HPI','Iveco','SK1400ME',13000);


insert into Avtomobili(idVozia,brSedista) values
 (1,5),
 (2,5),
 (3,5),
 (4,5);
 

insert into Motori(idVozim,kubikaza) values
 (5,124),
 (6,487),
 (7,998);
 

insert into Kombinja (idVozik,brSedista,nosivost) values
 (8,23,3500),
 (9,9,1111),
 (10,28,3000);
 

insert into IzdavSaloni (imeSal) values
  ('Vehicle Rent LMK'),
  ('Vehicle Rent LMK'),
  ('Vehicle Rent LMK'),
  ('Vehicle Rent LMK'),
  ('Vehicle Rent LMK'),
  ('Vehicle Rent LMK'),
  ('Vehicle Rent LMK'),
  ('Vehicle Rent LMK'),
  ('Vehicle Rent LMK'),
  ('Vehicle Rent LMK');

 
insert into IzdavSaloniBr(idIs, telBrIs) values
  (1,'+38976884225'),
  (2,'+38975226666'),
  (3, '+38971331545'),
  (4,'+38975667778'),
  (5,'+38976297789'),
  (6,'+38976333444'),
  (7,'+38971888777'),
  (8,'+38976995795'),
  (9,'+38976123569'),
  (10,'+38976333259');
  
 
insert into Klienti (EMBGK,imeK,adresaK,primiumK) values
        ('2602000455031', 'Jovana Trifunovska','Partizanska 25/2',False),
        ('1212993450002','Matej Pindzurovski','ASNOM 30',True),
        ('2510989443061','Slavko Borisov','Lece Koteski 12/1',False),
        ('1512992472001','Vikrot Najdenovski','Blagoja Toska 50',False),
        ('2903972599006','Bojana Sotiroska','Pirinska 28b',True),
        ('2989789555007','Alkaloid','Bulevar Aleksandar Makedonski 12',True),
        ('1595455777236','Husqarno','Воден 17',False),
        ('6542168546545','Replek','Козле 188',False),
        ('4552135462133','FarmaHen','Кичевска 1',True);
        
  
insert into FizickiL(EMBGKfl) values
        ('2602000455031'),
        ('1212993450002'),
        ('2510989443061'),
        ('1512992472001'),
        ('2903972599006');
        
  
insert into FizickiLBr(EMBGKfl,telBrFL ) values
        ('2602000455031','+38972325965'),
        ('1212993450002','+38971226694'),
        ('2510989443061','+38976369741'),
        ('1512992472001','+38975258159'),
        ('2903972599006','+38976159357');


insert into PravniL (EMBGKpl,direktor) values
        ('2989789555007','Jovan Nikolovski'),
        ('1595455777236','Kalina Jovanovska'),
        ('6542168546545','Jorde Bozinovski'),
        ('4552135462133','Martin Stojkoski');

  
insert into Dogovori (EMBGK,idIS,cenaDog,sklucenNa,vaziDo) values
  --'Q2','Audi'
        ('2602000455031',1,45000,to_date('0305022','ddmmyyy'),to_date('0905022','ddmmyyy')),
  --YZF-R1','Yamaha
        ('1212993450002',2,32500,to_date('1503022','ddmmyyy'),to_date('2003002','ddmmyyy')),
  --GS 500 F','SUZUKI
        ('2510989443061',3,11000,to_date('1002022','ddmmyyy'),to_date('1202022','ddmmyyy')),
  --ID.4','Volkswagen
        ('1512992472001',4, 56000, to_date('0601022','ddmmyy'),to_date('1401022','ddmmyyy')),
  --Dandy 12,Jawa
        ('2903972599006',2,35000,to_date('2006022','ddmmyy'),to_date('3006022','ddmmyyy')),
  --ID.4,Volkswagen
        ('2989789555007',1,21000,to_date('1509022','ddmmyyy'),to_date('1809022','ddmmyyy')),
  --A4,Audi
        ('1595455777236',6,38500,to_date('2612022','ddmmyyy'),to_date('0201023','ddmmyyy')),
  --Arteon,Volkswagen
        ('6542168546545',10,24000,to_date('1010022','ddmmyyy'),to_date('1410022','ddmmyyy')),
  -- SPRINTER,MERCEDES
        ('4552135462133',9,60000,to_date('0112022','ddmmyyy'),to_date('0612022','ddmmyyy'));

  
insert into Lokacii (idIS,adresaLok,gradLok ) values
        (1,'MK Автопат „Александар Македонски MK MK, Петровец 1043','Skopje'),
        (2,'Isaija Mazovski 30','Skopje'),
        (3,'Pitu Guli 15','Tetovo'),
        (4,'Охридска 26','Tetovo'),
        (5,'Bistra 16','Bitola'),
        (6,'Stiv Naumov 60','Strumica'),
        (7,'Egejska 90','Kicevo'),
        (8,'Sremska 5','Shtip'),
        (9,'Борис Кидриќ 6','Gostivar'),
        (10,'P.FAH 134 6000 MK','Ohrid');

  
insert into Vozaci(EMBGVoza,imeVoza,adresaVoza,vozackaD) values
  ('2602000455031', 'Jovana Trifunovska','Partizanska 25/2','A8964729'),
  ('1609998455032', 'Nikola Bozinovski','Partizanska 25/2','A1235469'),
  ('0906968450123', 'Kiril Pupinov','Partizanska 25/2','A7878950'),
  ('3007998450013', 'Bosko Jordanov','Partizanska 25/2','A5632458'),
  ('2609001450132', 'Daniel Simonovski','Partizanska 25/2','A3659874'),
  ('2705995442032', 'David Stefanovski','Partizanska 25/2','A1235498'),
  ('0409983450122', 'Stefan Dimitrovski','Partizanska 25/2','A3654780');
  
 
insert into VozaciBr(EMBGVoza,telBrVoza) values
        ('2602000455031','+38976422355'),
        ('1609998455032','+38975214569'),
        ('0906968450123','+38976125987'),
        ('3007998450013','+38971569987'),
        ('2609001450132','+38976159675'),
        ('2705995442032','+38975456987'),
        ('0409983450122','+39870268545');
        
  
insert into Msteti (idMS,idVozi,EMBGVoza,cenaMS) values 
        (1,1, '2602000455031', 123),
        (2,2, '1609998455032', 234),
        (3,3, '0906968450123', 345),
        (4,4, '3007998450013', 456),
        (5,5, '2609001450132', 567);


insert into Vraboteni (EMBGV,idIS,imeV) values 
        ('1129382121485',1,'Petar Nikolovski'),
        ('3129382130405',2,'Jovan Nikolovski'),
        ('2129382141415',3,'Sara Lilovska'),
        ('2129382150425',4,'Marija Dimitrovska');


insert into VraboteniBr (EMBGVbr, telBrV) values
        ('1129382121485', '+38975669043'),
        ('3129382130405', '+38975569423'),
        ('2129382141415', '+38975689117'),
        ('2129382150425', '+38975629793');


insert into Menadzeri (EMBGVM) values 
        ('1129382121485'),
        ('2129382141415'),
        ('2129382150425');


insert into Prodavachi (EMBGVP, EMBGVM) values 
        ('3129382130405', '1129382121485');


insert into Rezervacii (EMBGVoza, idDog, naDatumRez, doDatumRez) values
        ('2602000455031',1,to_date('0305022','ddmmyyy'),to_date('0906022','ddmmyyy')),
        ('1609998455032',2,to_date('0405022','ddmmyyy'),to_date('1006022','ddmmyyy')),
        ('0906968450123',3,to_date('1305022','ddmmyyy'),to_date('1905022','ddmmyyy')),
        ('3007998450013',4,to_date('2305022','ddmmyyy'),to_date('2805022','ddmmyyy')),
        ('2609001450132',5,to_date('1405022','ddmmyyy'),to_date('1905022','ddmmyyy')),
        ('2705995442032',6,to_date('2405022','ddmmyyy'),to_date('2805022','ddmmyyy')),
        ('0409983450122',7,to_date('1905022','ddmmyyy'),to_date('2905022','ddmmyyy'));
        
  
insert into ServisKomp (brSK, imeSK, adresaSK) values 
        (1, 'VehicleRentService','Nikola Karev 56'),
        (2, 'VehicleRentService2','Partizanska 40/2');


insert into ServisKompBr (brSK, telBrSK) values
        (1, '+389026759801'),
        (2, '+389047138745');


insert into Servisi (brSK, idVozi, cenaS, naDatumS) values
        (1,1, 2500, to_date('0305022','ddmmyyy')),
        (2,4, 4700, to_date('1411022','ddmmyyy'));


insert into Smetki (idDog, cenaSm, datumSm) values
        (1, 12500, to_date('0305022','ddmmyyy')),
        (2, 15600, to_date('0305022','ddmmyyy')),
        (3, 23500, to_date('0305022','ddmmyyy'));


insert into Parkirani (od, doD, idVozi, idIs) values
        (to_date('0305022','ddmmyyy'),to_date('2305022','ddmmyyy'),1,1),
        (to_date('1407022','ddmmyyy'),to_date('0306022','ddmmyyy'),2,1),
        (to_date('0101022','ddmmyyy'),to_date('0204022','ddmmyyy'),3,1);


insert into Naplati (brSM, EMBGVP, kesh, kartica, datumNap) values 
        (1,'3129382130405',true,false,to_date('0206022','ddmmyyy'));
--      (2,'3129382130405',false,true,to_date('1312022','ddmmyyy')),
--      (3,'2129382141415',true,false,to_date('2207022','ddmmyyy'));


insert into rezervacii_ima_za_vozila (idRez, idVozi) values
        (1,1),
        (2,2);
        

insert into vozaci_e_na_klienti (EMBGVoza, EMBGK) values
        ('2602000455031', '2602000455031'),
        ('1609998455032', '1212993450002'),
        ('0906968450123', '2510989443061'),
        ('3007998450013', '1512992472001'),
        ('2609001450132', '2903972599006'),
        ('2705995442032', '2989789555007');
        
  
insert into vozaci_ima_kategorii (EMBGVoza, idKat) values
        ('2602000455031',1),
        ('1609998455032',2),
        ('0906968450123',3),
        ('3007998450013',4),
        ('2609001450132',5),
        ('2705995442032',6), 
        ('0409983450122',7);