Select *
from tblZanr1;
insert into tblZaposleni1
values ('Marko1','12345','066325121','Strazilovska 1','Novi Sad','0512897891232','Markovic','Marko');
insert into tblZaposleni1
values ('Jovana1','123456','064325129','Jevrejska 1','Novi Sad','0511897891232','Jovanovic','Jovana');

insert into tblZaposleni1
values ('Petar22','1234512','066325122','Jevrejska 2','Novi Sad','0510895891232','Petrovic','Petar');

insert into tblZaposleni1
values ('Stefan1','123451','066325121','Dunavska 4','Novi Sad','0512888891232','Stefanovic','Stefan');

insert into tblZaposleni1
values ('Mara22','123451111','066325221','Dunavska 14','Novi Sad','0512828891232','Maric','Mara');

insert into tblKupac1
values ('Andrija','Tasic'),('Milos','Milosevic'),('Petar','Tasic'),('Aleksandar','Jovanovic'),('Kristijan','Stosic');
insert into tblSala1
values ('100','10'),('110','10'),('120','10'),('130','10'),('140','10');
select * from tblKupac1;
select * from tblZaposleni1;
select * from tblSala1;
select * from tblTipKarte1;
select * from tblZanr1;
select * from tblKarta1;
select * from tblFilm1;
insert into tblZanr1
values ('Horor'),('Komedija'),('Triler'),('Drama'),('Akcija');
insert into tblFilm1
values (2,2,2,'IT','1h 50m',8.7);
insert into tblFilm1
values (3,3,3,'Joker','2h 20m',9.7);
insert into tblFilm1
values (3,3,3,'Spiderman Homecoming','1h 30m',7.7);
insert into tblFilm1
values (3,3,3,'Harry Potter 2','1h 40 m',8.7);
DELETE from tblFilm1 where FilmID=7;
insert into tblKarta1
values (3,3,3,3,1,400,'15:00',1),(3,3,3,3,2,300,'17:00',1),(3,3,3,3,4,300,'19:00',1),(3,3,3,3,5,300,'21:00',1);

update tblZaposleni1 Set Ime='Milan',KorisnickoIme='Milan' where ZaposleniID=2;
update tblZaposleni1 Set Ime='Dragan',KorisnickoIme='Dragan1' where ZaposleniID=3;
update tblZaposleni1 Set Ime='Milos',KorisnickoIme='Milos2' where ZaposleniID=7;
update tblZaposleni1 Set Ime='Marija',KorisnickoIme='Marija1' where ZaposleniID=8;
update tblZaposleni1 Set Ime='Mihajlo',KorisnickoIme='Mihajlo1' where ZaposleniID=9;

update tblKupac1 Set Ime='Milan' where KupacID=1;
update tblKupac1 Set Ime='Dragan' where KupacID=2;
update tblKupac1 Set Ime='Milos' where KupacID=3;
update tblKupac1 Set Ime='Marija' where KupacID=4;
update tblKupac1 Set Ime='Mihajlo' where KupacID=5;

update tblSala1 Set BrojRedova=10,BrojSedista=101 where SalaID=1;
update tblSala1 Set BrojRedova=11,BrojSedista=102 where SalaID=2;
update tblSala1 Set BrojRedova=12,BrojSedista=103 where SalaID=3;
update tblSala1 Set BrojRedova=13,BrojSedista=104 where SalaID=4;
update tblSala1 Set BrojRedova=14,BrojSedista=105 where SalaID=5;

update tblTipKarte1 Set Obicna='da' where TipKarteID=1;
update tblTipKarte1 Set Obicna='da' where TipKarteID=2;
update tblTipKarte1 Set Obicna='da' where TipKarteID=3;
update tblTipKarte1 Set Obicna='da' where TipKarteID=4;
update tblTipKarte1 Set Obicna='da' where TipKarteID=5;

update tblZanr1 Set Zanr='Komedija' where ZanrFilmaID=1;
update tblZanr1 Set Zanr='Horor' where ZanrFilmaID=2;
update tblZanr1 Set Zanr='Triler' where ZanrFilmaID=3;
update tblZanr1 Set Zanr='Akcija' where ZanrFilmaID=4;
update tblZanr1 Set Zanr='Drama' where ZanrFilmaID=5;

update tblKarta1 Set Sediste=10,Cena=500 where KartaID=1;
update tblKarta1 Set Sediste=11,Cena=300 where KartaID=2;
update tblKarta1 Set Sediste=22,Cena=250 where KartaID=3;
update tblKarta1 Set Sediste=33,Cena=300 where KartaID=4;
update tblKarta1 Set Sediste=44,Cena=400 where KartaID=5;

update tblFilm1 Set Trajanje='2h 50',Rejting=5.5 where FilmID=1;
update tblFilm1 Set Trajanje='1h 35',Rejting=6.5 where FilmID=2;
update tblFilm1 Set Trajanje='1h 20',Rejting=7.5 where FilmID=3;
update tblFilm1 Set Trajanje='1h 30',Rejting=8.5 where FilmID=4;
update tblFilm1 Set Trajanje='1h 20',Rejting=9.5 where FilmID=5;

delete from tblZaposleni1 where ZaposleniID=2;
delete from tblFilm1 where FilmID=2;
delete from tblKarta1 where KartaID=2;
delete from tblTipKarte1 where TipKarteID=2;
delete from tblSala1 where SalaID=2;
delete from tblZanr1 where ZanrFilmaID=2;
delete from tblKupac1 where KupacID=2;