create table DEPARTMAN
(id INT IDENTITY(1,1), 
naziv varchar(100), 
primary key(id), 
unique (naziv)
);

create table STR_SPREMA
(id INT IDENTITY(1,1), 
naziv varchar(100), 
primary key(id), 
unique (naziv)
);

create table ZAPOSLENI(
jmbg char(13), 
ime varchar(100) not null, 
god_rodj int, 
s_sprema_id int,
primary key(jmbg), 
foreign key(s_sprema_id) references STR_SPREMA(id), 
check(god_rodj > 1900));

create table RADI(
dept_id int,
zap_jmbg char(13), 
r_vrijeme float, 
god_pocetka int, 
foreign key(dept_id) references DEPARTMAN(id), 
foreign key(zap_jmbg) references ZAPOSLENI(jmbg), 
primary key(dept_id, zap_jmbg));