mysql> create table  tutor (
    -> id_tut int not null unique auto_increment,
    -> fam_tut varchar( 25 ) not null,
    -> name_tut varchar( 15 ) not null,
    -> otch_tut varchar( 25 ) not null,
    -> primary key(id_tut));

mysql> create table test (
    -> id_test int not null unique auto_increment,
    -> fk_tuttest int not null,
    -> fk_distest int not null,
    -> name_test varchar( 40 ) ,
    -> info_test varchar( 100 ),
    -> primary key(id_test),
    -> constraint who_made
    -> foreign key(fk_tuttest)
    -> references tutor(id_tut));


mysql> create table discipline (
    -> id_dis int not null unique auto_increment,
    -> fk_tutdis int not null,
    -> name_dis varchar( 30 ),
    -> primary key(id_dis),
    -> constraint who_teach
    -> foreign key(fk_tutdis)
    -> references tutor(id_tut));

mysql> alter table test
    -> add constraint on_dis
    -> foreign key(fk_distest)
    -> references discipline(id_dis);