create table pais (cd_pais int primary key, nm_pais char(50) not null);

create table equipe (cd_eq int primary key, nm_eq char(50) not null, cd_pais int, foreign key (cd_pais) references pais);

create table piloto (cd_pil int primary key, nm_pil char(50) not null, cd_eq int, cd_pais int, foreign key (cd_eq) references equipe, foreign key (cd_pais) references pais);

create table circuito (cd_cir int primary key, nm_cir char(50), cd_pais int, foreign key (cd_pais) references pais);

create table prova (cd_pro int primary key, tp_pro int not null, dt_pro date not null, cd_cir int, foreign key (cd_cir) references circuito);

create table piloto_pos (cd_pil int, cd_pro int, posicao int not null, primary key (cd_pil, cd_pro), foreign key (cd_pil) references piloto, foreign key (cd_pro) references prova);