CREATE TABLE `propoj` (
  `id_student` int,
  `id_fakulta` int
);

CREATE TABLE `fakulta` (
  `id_fakulta` int,
  `Zkratka` varchar(5),
  `Cely_nazev` varchar(60)
);

CREATE TABLE `studenti` (
  `id_student` int,
  `jmeno` varchar(60),
  `prijmeni` varchar(60),
  `pohlavi` varchar(1),
  `PLAT` int,
  `datum_narozeni` date,
  `mesto` varchar(20),
  `fakulta` int
);


insert into fakulta values ('1', 'ESF', 'Ekonomicko spravni fakulta');
insert into fakulta values ('2', 'LAW', 'Právnícká fakulta');
insert into fakulta values ('3', 'MED', 'Lékarská fakulta');
insert into fakulta values ('4', 'SCI', 'Prirodovedecká fakulta');
insert into fakulta values ('5', 'PHI', 'Filozofická fakulta');
insert into fakulta values ('6', 'FI', 'Fakulta informatiky');
insert into fakulta values ('7', 'PED', 'Pedagogicka fakulta');
insert into fakulta values ('8', 'FSS', 'Sociální studia');

insert into propoj values ('1', '7');
insert into propoj values ('1', '1');
insert into propoj values ('2', '8');
insert into propoj values ('2', '2');
insert into propoj values ('3', '3');
insert into propoj values ('4', '1');
insert into propoj values ('5', '2');
insert into propoj values ('6', '3');
insert into propoj values ('7', '4');
insert into propoj values ('8', '5');
insert into propoj values ('9', '6');
insert into propoj values ('10', '7');


insert into studenti values ('1', 'jana', 'krátka', 'f', '23500', '1954-12-22', 'Brno', '0');
insert into studenti values ('2', 'Jana', 'Nováková', 'F', '42261', '2016-11-11', 'Brno', '1');
insert into studenti values ('3', 'Sophia', 'Santiago', 'F', '20758', '1962-11-16', 'Brno', '8');
insert into studenti values ('4', 'Jarek', 'Benes', 'M', '52483', '2017-06-11', 'Praha', '8');
insert into studenti values ('5', 'Petr', 'Malý', 'M', '10000', '2001-09-23', 'Praha', '8');
insert into studenti values ('6', 'Honza', 'Adamec', 'M', '29990', '1977-07-27', 'Praha', '7');
insert into studenti values ('7', 'Petra', 'Adamcova', 'F', '23500', '1982-03-16', 'Olomouc', '6');
insert into studenti values ('8', 'Zuzka', 'Bezva', 'F', '39752', '2016-02-29', 'Ostrava', '7');
insert into studenti values ('9', 'Ivan', 'Sobota', 'M', '15274', '1900-02-01', 'Pardubice', '3');
insert into studenti values ('10', 'Petr', 'Novak', 'M', '27679', '2002-05-20', 'Zlin', '2');



CREATE TABLE `studenti2` (
  `id_student` int,
  `jmeno` varchar(60),
  `prijmeni` varchar(60),
  `pohlavi` varchar(1),
  `PLAT` int,
  `datum_narozeni` date,
  `mesto` varchar(20),
  `fakulta` int
);



insert into studenti2 values ('7', 'Petra', 'Adamcova', 'F', '23500', '1982-03-16', 'Olomouc', '6');
insert into studenti2 values ('8', 'Zuzka', 'Bezva', 'F', '39752', '2016-02-29', 'Ostrava', '7');
insert into studenti2 values ('9', 'Ivan', 'Sobota', 'M', '15274', '1900-02-01', 'Pardubice', '3');
insert into studenti2 values ('10', 'Petr', NULL, 'M', '27679', '2002-05-20', NULL, '2');
insert into studenti2 values ('11', 'Jirka', 'Plavec', 'M', '23500', '2017-12-30', 'Opava', '1');