insertar informacion en la tabla fiestas

insert into fiestas values("1","02","003","001");
insert into fiestas values("8","02","003","001");
insert into fiestas values("14","02","04","01");
insert into fiestas values("9","02","04","01");
insert into fiestas values("7","02","01","01");
insert into fiestas values("5","02","01","01");
insert into fiestas values("2","01","01","02");
insert into fiestas values("11","01","01","02");
insert into fiestas values("4","01","02","02");
insert into fiestas values("18","01","02","02");
insert into fiestas values("3","01","04","02");
insert into fiestas values("16","01","04","02");
insert into fiestas values("13","02","05","03");
insert into fiestas values("10","02","05","03");
insert into fiestas values("6","02","02","03");
insert into fiestas values("17","02","02","03");
insert into fiestas values("15","02","03","03");
insert into fiestas values("12","02","03","03");
insert into fiestas values("19","02","03","03");

triggers

delimiter //
create trigger buganaderia before update on ganaderia for each row
begin
update from toros where id_ganaderia=OLD.id_ganaderia;
end //


delimiter //
create trigger bdganaderia before delete on ganaderia for each row
begin
delete from toros where id_ganaderia=OLD.id_ganaderia;
end //

Insercion de datos a las tablas apoderado,padrino y toreros

insert into apoderado values("001","BARV650909","Vicente Barrera","Torre Sur 41071","95-556-92-46");
insert into apoderado values("002","VENJ761021","Jose Carlos Venegas","Pontevedra Plaza De España 36002","95-556-21-38");

insert into torero values("001","001","ROPJ891002","Jose Antonio Rodriguez Perez","Jose Antonio Campuzano","0");
insert into torero values("002","001","PERJ781212","Jose Miguel Perez","Joselillo","0");
insert into torero values("003","001","LODE690124","Eulalio Lopez Diaz","El Zotoluco","1");
insert into torero values("004","002","RURJ910131","Juan Antonio Ruiz Roman","Espartaco","0");
insert into torero values("005","002","ROSM881122","Manuel Rodriguez Sanchez","Manolete","1");
insert into plazas values("001","Plaza De Toros De Pinos Puente","Granada,España","San Jeronimo 27","3000");
insert into plazas values("002","Plaza Monumental De Barcelona","Barcelona,España","Gran Via Corts Catalanes,749","19582");
insert into padrino values("2001-03-05",no posee,"003");
insert into padrino values("2008-08-21","003","005");

insertar informacion

insert into ganaderia values(01,"La_Herradura","Granada","01-ene-2000");
insert into ganaderia values(02,"El_Encino","Sevilla","28-may-1997");
insert into ganaderia values(03,"Valladolid","Barcelona","13-marz-2002");

insert into toros values(1,1,2007,"Pajarito","Negro",01);
insert into toros values(2,1,2008,"Bravo","Cafe",01);
insert into toros values(3,1,2008,"Luz","Gris",01);
insert into toros values(4,1,2007,"Toribio","Negro",01);
insert into toros values(5,1,2008,"Negro","Negro",01);
insert into toros values(6,2,2008,"Solitario","Negro",02);
insert into toros values(7,2,2010,"Loco","Gris",02);
insert into toros values(8,2,2007,"Expo","Negro",02);
insert into toros values(9,2,2008,"Maltrata","Gris",02);
insert into toros values(10,2,2009,"Sevilla","Cafe",02);
insert into toros values(11,2,2008,"Tarado","Negro",02);
insert into toros values(12,2,2007,"Pinto","Cafe",02);
insert into toros values(13,3,2008,"Tieso","Gris",03);
insert into toros values(14,3,2009,"Testa","Gris",03);
insert into toros values(15,3,2008,"Minotauro","Negro",03);
insert into toros values(16,3,2009,"Chocolate","Cafe",03);
insert into toros values(17,3,2007,"Ventorrillo","Negro",03);
insert into toros values(18,3,2008,"Ymbro","Negro",03);
insert into toros values(19,3,2009,"Tajo","Negro",03);

codigo de de mysql de la base de datos corrida

create database Fiesta_corridas;
show databases;
use Fiesta_corridas;
create table corrida (id_corrida char(10) not null, num_orden int, feria char(30), ano integer , primary key (id_corrida))TYPE = INNODB;

create table ganaderia (id_ganaderia char(10) not null,codigo char(15)not null,localidad char(30) not null,antiguedad int not null,primary key (id_ganaderia))TYPE = INNODB;

create table plazas (id_plazas char(10) not null,nombre char(30) not null,localidad char (20) not null,direccion char(40) not null,aforo int,primary key(id_plazas))TYPE = INNODB;

create table apoderado (id_apoderado char(10) not null,rfc char(15) not null,nombre char (50) not null,direccion char(40) not null,aforo int,telefono char (15),primary key(id_apoderado))TYPE = INNODB;

create table premios(id_premios char(10) not null,orejas int, rabos int,Puerta_grande bool,primary key(id_premios))TYPE = INNODB;

create table toros(
num_orden int not null,
id_ganaderia char(10) not null,
ano_nac time,
nombre char(20) not null,
color char(10),
orden_toreado int not null,
index (id_ganaderia),
foreign key (id_ganaderia) references ganaderia (id_ganaderia), on delete set null on update restrict)engine=innodb;


create table premio_torero(
id_premios char(10) not null,
index (id_premios),
foreign key (id_premios) references premios (id_premios) on delete cascade on update restrict,
id_torero char (10) not null,
index (id_torero),
foreign key (id_torero) references torero (id_torero) on delete cascade on update restrict,
id_corrida char (10) not null,
index (id_corrida),
foreign key (id_corrida) references corrida (id_corrida) on delete cascade on update cascade)engine=innodb;

create table padrino (
fecha_matador date not null,
id_torero char(10) not null,
index (id_torero),
foreign key (id_torero) references torero (id_torero) on delete cascade on update cascade)engine=innodb;

create table fiestas(
num_orden int not null,
index (num_orden),
foreign key (num_orden) references toros (num_orden) on delete cascade on update cascade,
id_plazas char(10),
index (id_plazas),
foreign key (id_plazas) references plazas (id_plazas) on delete set null on update restrict,
id_torero char(10),
index (id_torero),
foreign key (id_torero) references torero (id_torero) on delete set null on update cascade,
id_corrida char(10) not null,
index (id_corrida),
foreign key (id_corrida) references corrida (id_corrida) on delete cascade on update cascade)engine=innodb;

create table torero (
id_torero char(10) not null,
id_apoderado char(10) not null,
rfc char(10) not null,
nombre char(50),
apodo char(15) not null,
padrino bool not null, primary key (id_torero),
index(id_apoderado),
foreign key (id_apoderado) references apoderado (id_apoderado) on delete set null on update restrict)engine=innodb;

Diccionario de Datos

Diccionario de Datos

Diccionario de Datos

Integridad Referencial

Reglas De Negocio

Diagrama relacional