CREATE TABLE Korisnik(
    Email char(50) PRIMARY key NOT NULL,
    Ime char(20) NOT NULL,
    Prezime char(30) NOT NULL,
    Korisnicko_ime char(15) NOT NULL,
    Lozinka varchar(15) NOT NULL,
    Grad varchar(20) NOT NULL,
    Drzava varchar(20) NOT NULL,
    ZIP integer NOT NULL,
    Broj_ulica integer NOT NULL,
    Ime_ulica char(50) NOT NULL,
    Broj_apartman integer NOT NULL
);

CREATE TABLE Naplata(
ID_nanaplata integer primary key NOT NULL,
Nacin_naplata char(20) NOT NULL,
Email char(50) references Korisnik(Email)
);

CREATE TABLE Koshnica(
Br_koshnica integer PRIMARY key NOT NULL,
Kolichina integer,
Cena integer,
ID_naplata integer references Naplata(ID_nanaplata)
);

CREATE TABLE Kniga(
Naslov char(60) PRIMARY key NOT NULL,
Izadavac char(20) NOT NULL,
Godina_izdavanje integer NOT NULL,
Cena integer NOT NULL,
Zanr varchar(40) NOT NULL

);

CREATE TABLE Zaliha(
ID integer PRIMARY key NOT NULL,
Tip_korica char(5) NOT NULL,
Hartiena_forma integer,
Elektronska_forma integer,
Naslov char(60) references Kniga(Naslov)
);

CREATE TABLE Porachuva(
Email char(50) references Korisnik(Email),
Naslov char(60) references Kniga(Naslov)
);

CREATE TABLE Avtor(
Naslov char(60) references Kniga(Naslov),
Avtor char(70) NOT NULL
);

CREATE TABLE Sodrzi(
Naslov char(60) references Kniga(Naslov),
Br_koshnica integer references Koshnica(Br_koshnica)
);

INSERT INTO korisnik VALUES('aco-babic@hotmail.com','Aleksandar','Babic','137009','112233','Skopje','Makedonija',1000,26,'Fjodor Dostoevski',22);
INSERT INTO korisnik VALUES('despina_klisarova@hotmail.com','Despina','Klisarova','148002','123456','Skopje','Makedonija',1000,8,'Branislav Njusic',12);
INSERT INTO korisnik VALUES('marija.pakovska@yahoo.com','Marija','Pakovska','137007','654321','Skopje','Makedonija',1000,4,'Karposhovo vostanie',5);

INSERT INTO naplata VALUES(133,'transakcija','aco-babic@hotmail.com');
INSERT INTO naplata VALUES(453,'transakcija','despina_klisarova@hotmail.com');
INSERT INTO naplata VALUES(909,'transakcija','marija.pakovska@yahoo.com');

INSERT INTO koshnica VALUES(2365,5,3490,133);
INSERT INTO koshnica VALUES(1111,3,1290,453);
INSERT INTO koshnica VALUES(3255,6,7500,909);

INSERT INTO kniga VALUES('mort','gjurgja',2010,2500,'satira');
INSERT INTO kniga VALUES('marina','gjurgja',2001,1800,'drama');
INSERT INTO kniga VALUES('smrtta vozi audi','prosvetno delo',2016,990,'misterija');

INSERT INTO zaliha VALUES(333,'tvrda',55040,100000,'mort');
INSERT INTO zaliha VALUES(555,'meka',15000,80000,'marina');
INSERT INTO zaliha VALUES(543,'tvrda',65080,9000,'smrtta vozi audi');

INSERT INTO porachuva VALUES('aco-babic@hotmail.com','mort');
INSERT INTO porachuva VALUES('despina_klisarova@hotmail.com','marina');
INSERT INTO porachuva VALUES('marija.pakovska@yahoo.com','smrtta vozi audi');

INSERT INTO avtor VALUES('smrtta vozi audi','mihail bulgakov');
INSERT INTO avtor VALUES('mort','teri prachet');
INSERT INTO avtor VALUES('marina','karlos ruiz zafon');

INSERT INTO sodrzi VALUES('mort',2365);
INSERT INTO sodrzi VALUES('marina',1111);
INSERT INTO sodrzi VALUES('smrtta vozi audi',3255);