CREATE TABLE pobocky 
(
  id_pobocky NUMBER(2) PRIMARY KEY,
  nazev      VARCHAR2(20),
  mesto      VARCHAR2(13)
);

INSERT INTO pobocky VALUES(1, 'Finance','Praha');
INSERT INTO pobocky VALUES(2, 'Vyvoj','Brno');
INSERT INTO pobocky VALUES(3, 'Marketing','Praha');
INSERT INTO pobocky VALUES(4, 'Public Relation','Ostrava');


CREATE TABLE pracovnici 
(
  id_prac         NUMBER(4) PRIMARY KEY,
  jmeno           VARCHAR2(25),
  funkce          VARCHAR2(20),
  nadrizeny       NUMBER(4),
  nastoupil       DATE,
  mzda            NUMBER(7,2),
  id_pobocky      NUMBER(2)
);

INSERT INTO pracovnici VALUES
(1, 'Novak Alfonz','reditel', NULL, TO_DATE('01.01.1981', 'dd.mm.YYYY'), 50000, NULL);
INSERT INTO pracovnici VALUES
(2, 'Plha Jan','vedouci marketingu', 1, TO_DATE('01.01.1984', 'dd.mm.YYYY'), 32000, 3);
INSERT INTO pracovnici VALUES
(3, 'Kecal Jozef','vedouci pr', 1, TO_DATE('01.01.1992', 'dd.mm.YYYY'), 35000, 4);
INSERT INTO pracovnici VALUES
(4, 'Rach Petr','ucetni', 2, TO_DATE('01.01.1989', 'dd.mm.YYYY'), 18000, 1);
INSERT INTO pracovnici VALUES
(5, 'Kubikova Jana','prodejce', 2, TO_DATE('01.01.1997', 'dd.mm.YYYY'), 13000, 3);
INSERT INTO pracovnici VALUES
(6, 'Pekna Kamila','mluvci', 3, TO_DATE('01.01.1995', 'dd.mm.YYYY'), 27000, 4);
