CREATE TABLE `pracovnici` (
  `id` int,
  `jmeno prijmeni` varchar(70),
  `pohlavi` varchar(1),
  `PLAT` int,
  `datum_narozeni` date,
  `mesto` varchar(20),
  `id_divize` int
);


CREATE TABLE `divize` (
  `id_divize` int,
  `Zkratka` varchar(5),
  `Cely nazev oddeleni` varchar(60)
);



insert into pracovnici values ('1', 'Jana Krátka', 'F', '23500', '1954-12-22', 'Brno', '1');
insert into pracovnici values ('2', 'Jana Nováková', 'F', '42261', '2016-11-11', 'Brno', '6');
insert into pracovnici values ('3', 'Sophia Santiago', 'F', '20758', '1962-11-16', 'Brno', '2');
insert into pracovnici values ('4', 'Jarek Benes', 'M', '52483', '2017-06-11', 'Praha', '9');
insert into pracovnici values ('5', 'Petr Malý', 'M', '10000', '2001-09-23', 'Praha', '2');
insert into pracovnici values ('6', 'Honza Adamec', 'M', '29990', '1977-07-27', 'Praha', '2');
insert into pracovnici values ('7', 'Petra Adamcova', 'F', '23500', '1982-03-16', 'Olomouc', '6');
insert into pracovnici values ('8', 'Zuzka Bezva', 'F', '39752', '2016-02-29', 'Ostrava', '6');
insert into pracovnici values ('9', 'Ivan Sobota', 'M', '15274', '1900-02-01', 'Pardubice', '7');
insert into pracovnici values ('10', 'Petr Novak', 'M', '27679', '2002-05-20', 'Zlin', '6');
insert into pracovnici values ('11', 'Jirka Plavec', 'M', '23500', '2017-12-30', 'Opava', '1');
insert into pracovnici values ('12', 'Iva Nováková', 'F', '25371', '2007-06-07', 'Opava', '8');
insert into pracovnici values ('13', 'Ivan Kurzo', 'M', '10000', '2018-02-22', 'Ostrava', '6');
insert into pracovnici values ('14', 'Petr Novak', 'M', '21072', '2011-06-15', 'Pardubice', '5');
insert into pracovnici values ('15', 'Iva Nováková', 'F', '23181', '1994-02-13', 'Brno', '8');
insert into pracovnici values ('16', 'Ela Nová', 'F', '23500', '1987-12-14', 'Brno', '9');
insert into pracovnici values ('17', 'Jan Novak', 'M', '49213', '1979-08-19', 'Brno', '7');
insert into pracovnici values ('18', 'petr novak', 'M', '18638', '1960-11-18', 'Brno', '1');
insert into pracovnici values ('19', 'Tom Krejza', 'M', '21086', '2017-09-24', 'Brno', '5');
insert into pracovnici values ('20', 'Ida Krejzova', 'F', '54032', '2017-04-03', 'Brno', '2');
insert into pracovnici values ('21', 'Pavel Pavel', 'M', '23500', '2014-03-14', 'Brno', '8');
insert into pracovnici values ('22', 'Jakub Nedelka', 'M', '50900', '2017-05-16', 'Praha', '7');
insert into pracovnici values ('23', 'Zuzka Lesní', 'F', '49956', '2001-09-23', 'Brno', '4');
insert into pracovnici values ('24', 'Zuzana Jarní', 'F', '10000', '2001-09-23', 'Brno', '9');
insert into pracovnici values ('25', 'Ela Melera', 'F', '10000', '1994-02-13', 'Brno', '6');
insert into pracovnici values ('26', 'jana krátka', 'f', '23500', '1954-12-22', 'Brno', '8');
insert into pracovnici values ('27', 'Jana Nováková', 'F', '42261', '2016-11-11', 'Brno', '6');
insert into pracovnici values ('28', 'Sophia Santiago', 'F', '20758', '1962-11-16', 'Brno', '6');
insert into pracovnici values ('29', 'Jarek Benes', 'M', '52483', '2017-06-11', 'Praha', '3');
insert into pracovnici values ('30', 'Petr Malý', 'M', '10000', '2001-09-23', 'Praha', '1');
insert into pracovnici values ('31', 'Honza Adamec', 'M', '29990', '1977-07-27', 'Praha', '1');
insert into pracovnici values ('32', 'Petra Adamcova', 'F', '23500', '1982-03-16', 'Olomouc', '1');
insert into pracovnici values ('33', 'Zuzka Bezva', 'F', '39752', '2016-02-29', 'Ostrava', '4');
insert into pracovnici values ('34', 'Ivan Sobota', 'M', '15274', '1900-02-01', 'Pardubice', '2');
insert into pracovnici values ('35', 'Petr Novak', 'M', '27679', '2002-05-20', 'Zlin', '8');
insert into pracovnici values ('36', 'Jirka Plavec', 'M', '23500', '2017-12-30', 'Opava', '5');
insert into pracovnici values ('37', 'Iva Nováková', 'F', '25371', '2007-06-07', 'Opava', '6');
insert into pracovnici values ('38', 'Ivan Kurzo', 'M', '10000', '2018-02-22', 'Ostrava', '3');
insert into pracovnici values ('39', 'Petr Novak', 'M', '21072', '2011-06-15', 'Pardubice', '7');
insert into pracovnici values ('40', 'Iva Nováková', 'F', '23181', '1994-02-13', 'Brno', '1');
insert into pracovnici values ('41', 'Ela Nová', 'F', '23500', '1987-12-14', 'Brno', '6');
insert into pracovnici values ('42', 'Jan Novak', 'M', '49213', '1979-08-19', 'Brno', '5');
insert into pracovnici values ('43', 'petr novak', 'M', '18638', '1960-11-18', 'Brno', '3');
insert into pracovnici values ('44', 'Tom Krejza', 'M', '21086', '2017-09-24', 'Brno', '8');
insert into pracovnici values ('45', 'Ida Krejzova', 'F', '54032', '2017-04-03', 'Brno', '9');
insert into pracovnici values ('46', 'Pavel Pavel', 'M', '23500', '2014-03-14', 'Brno', '2');
insert into pracovnici values ('47', 'Jakub Nedelka', 'M', '50900', '2017-05-16', 'Praha', '3');
insert into pracovnici values ('48', 'Zuzka Lesní', 'F', '49956', '2001-09-23', 'Brno', '4');
insert into pracovnici values ('49', 'Zuzana Jarní', 'F', '10000', '2001-09-23', 'Brno', '5');
insert into pracovnici values ('50', 'Ela Melera', 'F', '10000', '1994-02-13', 'Brno', '4');
insert into pracovnici values ('51', 'jana krátka', 'f', '23500', '1954-12-22', 'Brno', '4');
insert into pracovnici values ('52', 'Jana Nováková', 'F', '42261', '2016-11-11', 'Brno', '6');
insert into pracovnici values ('53', 'Sophia Santiago', 'F', '20758', '1962-11-16', 'Brno', '4');
insert into pracovnici values ('54', 'Jarek Benes', 'M', '52483', '2017-06-11', 'Praha', '2');
insert into pracovnici values ('55', 'Petr Malý', 'M', '10000', '2001-09-23', 'Praha', '3');
insert into pracovnici values ('56', 'Honza Adamec', 'M', '29990', '1977-07-27', 'Praha', '2');
insert into pracovnici values ('57', 'Petra Adamcova', 'F', '23500', '1982-03-16', 'Olomouc', '3');
insert into pracovnici values ('58', 'Zuzka Bezva', 'F', '39752', '2016-02-29', 'Ostrava', '1');
insert into pracovnici values ('59', 'Ivan Sobota', 'M', '15274', '1900-02-01', 'Pardubice', '5');
insert into pracovnici values ('60', 'Petr Novak', 'M', '27679', '2002-05-20', 'Zlin', '9');
insert into pracovnici values ('61', 'Jirka Plavec', 'M', '23500', '2017-12-30', 'Opava', '8');
insert into pracovnici values ('62', 'Iva Nováková', 'F', '25371', '2007-06-07', 'Opava', '4');
insert into pracovnici values ('63', 'Ivan Kurzo', 'M', '10000', '2018-02-22', 'Ostrava', '9');
insert into pracovnici values ('64', 'Petr Novak', 'M', '21072', '2011-06-15', 'Pardubice', '2');
insert into pracovnici values ('65', 'Iva Nováková', 'F', '23181', '1994-02-13', 'Brno', '5');
insert into pracovnici values ('66', 'Ela Nová', 'F', '23500', '1987-12-14', 'Brno', '1');
insert into pracovnici values ('67', 'Jan Novak', 'M', '49213', '1979-08-19', 'Brno', '7');
insert into pracovnici values ('68', 'petr novak', 'M', '18638', '1960-11-18', 'Brno', '3');
insert into pracovnici values ('69', 'Tom Krejza', 'M', '21086', '2017-09-24', 'Brno', '6');
insert into pracovnici values ('70', 'Ida Krejzova', 'F', '54032', '2017-04-03', 'Brno', '3');
insert into pracovnici values ('71', 'Pavel Pavel', 'M', '23500', '2014-03-14', 'Brno', '7');
insert into pracovnici values ('72', 'Jakub Nedelka', 'M', '50900', '2017-05-16', 'Praha', '7');
insert into pracovnici values ('73', 'Zuzka Lesní', 'F', '49956', '2001-09-23', 'Brno', '2');
insert into pracovnici values ('74', 'Zuzana Jarní', 'F', '10000', '2001-09-23', 'Brno', '4');
insert into pracovnici values ('75', 'Ela Melera', 'F', '10000', '1994-02-13', 'Brno', '1');


insert into divize values ('1', 'GR', 'reditelstvi');
insert into divize values ('2', 'LW', 'pravni oddeleni');
insert into divize values ('3', 'PR', 'reklamni oddeleni');
insert into divize values ('4', 'VV', 'vyroba');
insert into divize values ('5', 'HR', 'lidske zdroje');
insert into divize values ('6', 'EK', 'ekonomicke oddeleni');