select nom, nom_race as race

from animal join resume on animal.id_animal = resume.id_animal

join races on resume.id_race = race.idrace

drop table if exists dogs, races ;



create table races

( id integer		auto_increment

, name char(100)	not null



, primary key (id)

) engine = innodb ;



create table dogs

( id integer		auto_increment

, name char(100)	not null

, race_id integer	default null



, primary key (id)

, foreign key (race_id) references races(id)

) engine = innodb ;



insert into races (name) values

	('Pékinois'), ('Caniche'), ('Chiwawa'), ('Boxer') ;



insert into dogs (name, race_id) values

	('Gros bâtard', null), ('Dorothée', (select id from races where name = 'Caniche')) ;