DijagramiZaSistemot: sql.txt

create table Kompanija(
ime varchar2(50) primary key,
drzava varchar2(50) not null,
lokacija varchar2(50) not null
);
create table Distributeri(
id_distributer number primary key,
email varchar2(50) not null,
ime_prezime varchar2(100) not null,
zarabotka number not null,
ime_dostavuva_katalozi varchar2(50) not null references kompanija(ime),
ime_dostavuva_naracki varchar2(50) not null references kompanija(ime)
);
create table Katalog (
id_katalog number primary key,
cena number not null,
id_proizvod number not null,
ime_go_objavuva varchar2(50) not null references kompanija(ime)
);
create table Klient(
naziv varchar2(100) primary key,
adresa varchar2(100) not null,
email varchar2(100) not null,
tel_broj varchar2(50) not null
);
create table razgleduva(
id_katalog number not null references katalog(id_katalog), 
naziv varchar2(100) not null references klient(naziv),
primary key(id_katalog,naziv)
);
create table pravi_naracki_preku(
id_distributer number not null references distributer(id_distributer),
naziv varchar2(100) not null references klient(naziv),
primary key(id_distributer,naziv)
);
create table dostavuva_katalozi_za(
id_distributer number not null references distributer(id_distributer),
naziv varchar2(100) not null references klient(naziv),
primary key(id_distributer,naziv)
);
create table Tip_distributer(
id_distributer number primary key references distributer(id_distributer),
nagradi number not null,
provizija number not null
);
create table standard(
id_distributer number primary key references tip_distributer(id_distributer)
);
create table pocetnik(
id_distributer number primary key references tip_distributer(id_distributer)
);
create table vip(
id_distributer number primary key references tip_distributer(id_distributer)
);