CREATE TABLE oddeleni (oddeleni_id number primary key, nazev varchar2(20))

CREATE TABLE bydliste (bydliste_id number primary key, mesto varchar2(20))


CREATE TABLE ZAMESTNANEC (ZAMESTNANEC_ID NUMBER PRIMARY KEY, JMENO VARCHAR2(30),PRIJMENI VARCHAR2(30),BYDLISTE NUMBER REFERENCES BYDLISTE(BYDLISTE_ID),ODDELENI NUMBER REFERENCES ODDELENI(ODDELENI_ID),ROK_NAROZENI NUMBER, NADRIZENY NUMBER REFERENCES ZAMESTNANEC(ZAMESTNANEC_ID)

Insert into oddeleni values(1,'Vedeni')
Insert into oddeleni values(2,'Uctarna')
Insert into oddeleni values(3,'Sklad')
Insert into oddeleni values(4,'Prodejna')

Insert into bydliste values(1,'Brno')
Insert into bydliste values(2,'Praha')
Insert into bydliste values(3,'Ostrava')
Insert into bydliste values(4,'Olomouc')