CREATE TABLE Tarif(
   Id INT NOT NULL,
   Mzda DECIMAL(6, 0) NOT NULL,
   PRIMARY KEY(Id)
);
 
CREATE TABLE Funkce(
   Id INT NOT NULL,
   Nazev VARCHAR(20) NOT NULL,
   PRIMARY KEY(Id)
);
 
CREATE TABLE Odbor(
   Id INT NOT NULL,
   VedouciId INT NOT NULL,
   Nazev VARCHAR(20) NOT NULL,
   PRIMARY KEY(Id),
   UNIQUE(VedouciId)
);
 
CREATE TABLE Pracovnik(
   Id INT NOT NULL,
   FunkceId INT NOT NULL,
   TarifId INT NOT NULL,
   Jmeno VARCHAR(20) NOT NULL,
   PRIMARY KEY(Id)
);
 
CREATE TABLE Obsazeni(
   OdborId INT NOT NULL,
   PracovnikId INT NOT NULL,
   UNIQUE(OdborId, PracovnikId)
);
 
CREATE TABLE Zadost(
   Id INT NOT NULL,
   OdborId INT NOT NULL,
   PracovnikId INT NULL,
   Stav CHAR(1) NOT NULL,
   Popis VARCHAR(100) NOT NULL,
   PRIMARY KEY(Id)
);