DB

 create table kino(id int primary key identity(1,1),nazev_kina varchar(20));

 create table film(id int primary key identity(1,1),nazev_filmu varchar(20));

 create table program(id int primary key identity(1,1),nazev_programu varchar(10) not null unique,
 kino_id int not null, constraint fk_program_kino foreign key(kino_id) references kino,
 film_id int not null, constraint fk_program_film foreign key(film_id) references film);

 alter table program add datum date;
 alter table film add delka_min int;