insert into proprietaire values (1,'martin','orleans'); 
insert into proprietaire values (2,'dupont','lille');
insert into proprietaire values (3,'voisin','orleans'); 
insert into proprietaire values (4,'roger','orleans'); 
insert into proprietaire values (5,'maxime','lille'); 
insert into proprietaire values (6,'dupuis','lille'); 
insert into proprietaire values (7,'roland','orleans'); 
insert into proprietaire values (8,'lucien','lille'); 
insert into proprietaire values (9,'armand','orleans'); 
insert into proprietaire values (10,'michou','lille');
insert into proprietaire values (11,'algor','paris'); 
insert into proprietaire values (12,'tonio','paris'); 
insert into proprietaire values (13,'vaudou','paris'); 
insert into proprietaire values (14,'gourou','lannion');
insert into proprietaire values (15,'robin','orleans'); 
insert into proprietaire values (16,'mimine','paris'); 
insert into proprietaire values (17,'alibaba','lannion');
insert into proprietaire values (18,'clinton','tours');
insert into proprietaire values (19,'durant','tours'); 
insert into proprietaire values (20,'florent','lannion'); 
insert into proprietaire values (21,'devergne','tours');
insert into proprietaire values (22,'nicolas','orleans'); 
insert into proprietaire values (23,'sabrina','tours'); 
insert into proprietaire values (24,'david','orleans'); 
insert into proprietaire values (25,'gisele','orleans'); 
insert into proprietaire values (26,'durand','orleans');
insert into proprietaire values (27,'tintin','lille');

insert into chien values ('EPA106','bugloss ','epagneul','M',to_date
('25/05/1998','DD/MM/YYYY'),25,NULL); 
insert into chien values ('EPA103','doudoune ','epagneul','F',to_date
('25/05/1998','DD/MM/YYYY'),25,NULL); 
insert into chien values ('EPA101','doudoune ','epagneul','F',to_date
('27/03/2000','DD/MM/YYYY'),25,NULL);
insert into chien values ('GRI110','wawaf','griffon','M',to_date
('26/05/1993','DD/MM/YYYY'),6,to_date('17/10/2000','DD/MM/YYYY') ); 
insert into chien values ('GRI111','poulish','griffon','F',to_date
('05/03/1991','DD/MM/YYYY'),26,NULL);
insert into chien values ('GRI112','mercedes','griffon','F',to_date
('07/08/1994','DD/MM/YYYY'),26,NULL );
insert into chien values ('GRI116','micky','griffon','M',to_date
('07/08/1994','DD/MM/YYYY'),26,to_date ('17/10/2000','DD/MM/YYYY'));
insert into chien values ('SBER125','paf','st_bernard','M',to_date
('8/09/1994','DD/MM/YYYY'),24, NULL); 
insert into chien values ('SBER126','beauty','st_bernard','M',to_date
('8/09/1944','DD/MM/YYYY'),24, NULL); 
insert into chien values ('SBER127','flipflap ','st_bernard','F',to_date
('5/08/1997','DD/MM/YYYY'),8,NULL); 
insert into chien values ('SBER128','groumou ','st_bernard','M',to_date
('10/11/1992','DD/MM/YYYY'),21,to_date('15/08/2000','DD/MM/YYYY'));
insert into chien values ('SBER120','medor','st_bernard','M',to_date
('10/11/1956','DD/MM/YYYY'),21,to_date('15/08/1998','DD/MM/YYYY'));
insert into chien values ('SBER121','chila','st_bernard','F',to_date
('10/11/1956','DD/MM/YYYY'),21,to_date('15/08/2000','DD/MM/YYYY'));
insert into chien  values('CAN010','idefix','caniche','M',
to_date('12/07/1998','DD/MM/YYYY'),1,NULL); 
insert into chien  values('CAN001','loulou','caniche','M',
to_date('19/06/1996','DD/MM/YYYY'),1,NULL); 
insert into chien values ('CAN011','lulu','caniche','F',to_date
('25/05/1989','DD/MM/YYYY'),2,to_date
('22/04/2000','DD/MM/YYYY')); 
insert into chien values ('CAN017','bouboule','caniche','F',to_date
('15/09/1996','DD/MM/YYYY'),1,NULL); 
insert into chien values ('CAN015','lulu','caniche','F',to_date
('15/09/1985','DD/MM/YYYY'),2,to_date('22/04/2000','DD/MM/YYYY')); 
insert into chien values ('CAN012','bouboule','caniche','F',to_date
('15/09/1995','DD/MM/YYYY'),3,NULL);
insert into chien values ('CAN016','lolo','caniche','F',to_date
('25/05/1987','DD/MM/YYYY'),2,to_date('22/04/2000','DD/MM/YYYY')); 
insert into chien values ('CAN019','bouboule','caniche','F',to_date
('15/09/1990','DD/MM/YYYY'),1,NULL); 
insert into chien values ('CAN099','toutou','caniche','F',to_date
('15/09/1990','DD/MM/YYYY'),1,NULL); 
insert into chien values ('CAN013','wagadoudou','caniche','M',to_date
('19/06/1996','DD/MM/YYYY'),4,NULL); 
insert into chien values ('CAN014','charlotte','caniche','F',to_date
('09/11/1995','DD/MM/YYYY'),5,NULL);
insert into chien values ('CAN018','tarlouze','caniche','M',to_date
('09/11/1985','DD/MM/YYYY'),5,NULL);
insert into chien values ('LAB020','louloute','labrador','F',to_date
('12/05/1984','DD/MM/YYYY'),6, to_date ('06/06/1994','DD/MM/YYYY')); 
insert into chien values ('LAB022','looping','labrador','M',to_date
('24/09/1984','DD/MM/YYYY'),6,to_date ('16/08/1999','DD/MM/YYYY'));  
insert into chien values ('LAB023','elastoc','labrador','M',to_date
('25/12/1997','DD/MM/YYYY'),7,NULL); 
insert into chien values ('LAB024','sam','labrador','M',to_date
('14/01/1999','DD/MM/YYYY'),8,NULL); 
insert into chien values ('LAB025','choupette','labrador','F',to_date
('25/12/1997','DD/MM/YYYY'),9,NULL );
insert into chien values ('LAB026','maxou','labrador','M',to_date
('25/12/1997','DD/MM/YYYY'),10,NULL);
insert into chien values ('GOL032','pepette ','golden retriever','F',to_date 
('22/06/1989','DD/MM/YYYY'),11,to_date ('23/04/1998','DD/MM/YYYY')); 
insert into chien values ('GOL036','maya','golden retriever','F',to_date
('01/02/1996','DD/MM/YYYY'),10,NULL);
insert into chien values ('GOL034','poupouille ','golden retriever','M',to_date
('01/02/1996','DD/MM/YYYY'),12,to_date ('03/05/1999','DD/MM/YYYY')); 
insert into chien values ('GOL033','conquerant ','golden retriever ','M',to_date
('05/05/1998','DD/MM/YYYY'),12,NULL); 
insert into chien values ('GOL039','poupoule ','golden retriever
','M',to_date('23/06/1992','DD/MM/YYYY'),5,NULL);
insert into chien values ('FOX041','toufou','fox_terrier','M',to_date
('05/07/1994','DD/MM/YYYY'),27,NULL); 
insert into chien values ('FOX045','milou ','fox_terrier','M',to_date
('25/06/1979','DD/MM/YYYY'),27,to_date ('23/05/1997','DD/MM/YYYY'));
insert into chien values ('FOX047','teddy ','fox_terrier','F',to_date
('05/07/1994','DD/MM/YYYY'),2,NULL); 
insert into chien values ('FOX044','sim ','fox_terrier','M',to_date
('02/02/1997','DD/MM/YYYY'),3,NULL);
insert into chien values ('FOX049','chiffon ','fox_terrier','F',to_date
('28/08/1986','DD/MM/YYYY'),11,to_date ('21/04/1999','DD/MM/YYYY'));
insert into chien values ('BER055','mad','berger_all','F',to_date ('11/05/1996',
'DD/MM/YYYY'),12,NULL); 
insert into chien values ('BER053','bibou ','berger_all','F',to_date ('11/05/1996','DD/MM/YYYY'),11,to_date ('22/02/2000','DD/MM/YYYY'));
insert into chien values ('BOUL060','timon','bouledog','M',to_date ('13/12/1996','DD/MM/YYYY'),19,NULL); 
insert into chien values ('BOUL069','poumba','bouledog','M',to_date ('01/05/1988','DD/MM/YYYY'),20,to_date ('22/02/2000','DD/MM/YYYY') ); 
insert into chien values ('BOUL061','jasmine','bouledog','F',to_date ('11/09/1992','DD/MM/YYYY'),9,NULL);
insert into chien values ('PITT070','rantanplan','pittbull','M',to_date
('15/09/1982','DD/MM/YYYY'),21,to_date ('19/06/1998','DD/MM/YYYY'));
insert into chien values ('DOB080','doudouce','doberman','F',to_date 
('12/12/1988','DD/MM/YYYY'),20,to_date ('25/12/1996','DD/MM/YYYY')); 
insert into chien values ('DOB081','moustache','doberman','M',to_date 
('15/08/1991','DD/MM/YYYY'), 22,to_date ('15/06/1998','DD/MM/YYYY')); 
insert into chien values ('DOB083','barbus','doberman','M',to_date
('04/04/1985','DD/MM/YYYY'),23,NULL);
insert into chien values ('DOB087','brutus','doberman','F',to_date 
('03/03/1997','DD/MM/YYYY'),24,NULL);
insert into chien values ('DOB088','gagnant','doberman','M',to_date
('31/01/1987','DD/MM/YYYY'),22,to_date ('09/09/1992','DD/MM/YYYY')); 
insert into chien values ('DOB089','falco','doberman','M',to_date
('29/02/1996','DD/MM/YYYY'),22,NULL);
insert into chien values ('MUF530','indra ','husky','F',to_date
('28/04/1991','DD/MM/YYYY'),3,NULL); 
insert into chien values ('MUF531','titi ','husky','M',to_date
('28/04/1982','DD/MM/YYYY'),3,NULL); 
insert into chien values ('MUF532','chichi','husky','F',to_date
('28/04/1991','DD/MM/YYYY'),3,NULL); 
insert into chien values ('MUF538','roger','husky','M',to_date
('28/04/1978','DD/MM/YYYY'),3,NULL); 
insert into chien values ('MUF536','pallas','husky','F',to_date
('28/04/1977','DD/MM/YYYY'),3,NULL); 
insert into chien values ('MUF534','topaze','husky','M',to_date
('28/05/1978','DD/MM/YYYY'),3,NULL); 
insert into chien values ('MUF533','emeraude','husky','F',to_date
('30/06/1976','DD/MM/YYYY'),3,NULL); 
insert into chien values ('MUF535','harley','husky','M',to_date
('05/11/1992','DD/MM/YYYY'),3,to_date ('10/10/2000','DD/MM/YYYY') ); 
insert into chien values ('MUF537','motors','husky','M',to_date
('25/07/1996','DD/MM/YYYY'),13,NULL);
insert into chien values ('EPA100','gaspars ','epagneul','M',to_date
('28/07/1991','DD/MM/YYYY'),14,to_date ('28/07/1999','DD/MM/YYYY' )); 
insert into chien values ('EPA102','bagherra ','epagneul','F',to_date
('27/08/1990','DD/MM/YYYY'),15,NULL); 


insert into concours values (101,'lyon','beaute',to_date ('25/08/1987','DD/MM/YYYY')); 
insert into concours values (102,'lyon','beaute',to_date ('19/07/1992','DD/MM/YYYY')); 
insert into concours values (103,'lyon','beaute',to_date ('25/08/1993','DD/MM/YYYY')); 
insert into concours values (104,'lyon','beaute',to_date ('25/01/1995','DD/MM/YYYY')); 
insert into concours values (105,'lyon','beaute',to_date ('18/08/1997','DD/MM/YYYY')); 
insert into concours values (106,'lyon','beaute',to_date ('28/11/1998','DD/MM/YYYY')); 
insert into concours values (107,'lyon','beaute',to_date ('15/05/1999','DD/MM/YYYY')); 
insert into concours values (108,'lyon','beaute',to_date ('28/09/2000','DD/MM/YYYY')); 
insert into concours values (109,'lyon','beaute',to_date ('18/07/1998','DD/MM/YYYY')); 
 insert into concours values (110,'orleans','beaute',to_date ('15/03/1946','DD/MM/YYYY'));
insert into concours values (111,'orleans','chasse',to_date ('15/10/1992','DD/MM/YYYY'));
insert into concours values (112,'orleans','chasse',to_date ('19/05/1993','DD/MM/YYYY'));
insert into concours values (113,'orleans','chasse',to_date ('14/07/1991','DD/MM/YYYY'));
insert into concours values (114,'orleans','chasse',to_date ('05/11/1997','DD/MM/YYYY'));
insert into concours values (115,'orleans','chasse',to_date ('15/10/1987','DD/MM/YYYY'));
insert into concours values (116,'orleans','chasse',to_date ('19/05/1988','DD/MM/YYYY'));
insert into concours values (117,'orleans','chasse',to_date ('24/05/1990','DD/MM/YYYY'));
insert into concours values (118,'orleans','chasse',to_date ('08/07/1989','DD/MM/YYYY'));
insert into concours values (119,'orleans','chasse',to_date ('24/09/1996','DD/MM/YYYY'));
insert into concours values (120,'orleans','chasse',to_date ('06/12/1998','DD/MM/YYYY'));


insert into concours values (121,'paris','endurance',to_date ('15/05/1991','DD/MM/YYYY'));
insert into concours values (122,'paris','endurance',to_date ('18/06/1992','DD/MM/YYYY'));
insert into concours values (123,'paris','endurance',to_date ('18/05/1993','DD/MM/YYYY'));
insert into concours values (124,'paris','endurance',to_date ('17/07/1994','DD/MM/YYYY'));
insert into concours values (125,'paris','endurance',to_date ('28/11/1996','DD/MM/YYYY'));
insert into concours values (126,'paris','endurance',to_date ('28/11/1995','DD/MM/YYYY'));
insert into concours values (127,'paris','endurance',to_date ('12/05/1997','DD/MM/YYYY'));
insert into concours values (128,'paris','endurance',to_date ('18/07/1998','DD/MM/YYYY'));
insert into concours values (129,'paris','endurance',to_date ('23/12/1999','DD/MM/YYYY'));
insert into concours values (130,'paris','endurance',to_date ('12/07/2000','DD/MM/YYYY'));
insert into concours values (131,'paris','endurance',to_date ('20/05/1988','DD/MM/YYYY')); 

insert into concours values (140,'nice','vitesse',to_date ('12/12/1993','DD/MM/YYYY'));
insert into concours values (141,'nice','vitesse',to_date ('08/07/1994','DD/MM/YYYY'));
insert into concours values (142,'nice','vitesse',to_date ('01/01/1995','DD/MM/YYYY'));
insert into concours values (143,'nice','vitesse',to_date ('18/04/1996','DD/MM/YYYY'));
insert into concours values (144,'nice','vitesse',to_date ('15/02/1997','DD/MM/YYYY'));
insert into concours values (145,'nice','vitesse',to_date ('11/05/1998','DD/MM/YYYY'));
insert into concours values (146,'nice','vitesse',to_date ('09/09/1999','DD/MM/YYYY'));



insert into participe values ('CAN010',107);
insert into participe values ('CAN010',129);
insert into participe values ('CAN010',108);
insert into participe values ('CAN011',113);
insert into participe values ('CAN011',104);
insert into participe values ('CAN012',106);
insert into participe values ('CAN013',114);
insert into participe values ('CAN013',145);
insert into participe values ('CAN013',107);
insert into participe values ('CAN015',116);
insert into participe values ('CAN015',117);
insert into participe values ('CAN015',123);
insert into participe values ('CAN015',124);
insert into participe values ('CAN015',143);
insert into participe values ('CAN015',105);
insert into participe values ('CAN016',118);
insert into participe values ('CAN016',104);
insert into participe values ('CAN016',106);
insert into participe values ('CAN016',109);
insert into participe values ('CAN017',106);
insert into participe values ('CAN016',119);
insert into participe values ('CAN017',125);
insert into participe values ('CAN017',127);
insert into participe values ('CAN017',109);
insert into participe values ('CAN019',127);
insert into participe values ('CAN019',125);
insert into participe values ('CAN019',112);
insert into participe values ('CAN019',120);
insert into participe values ('CAN019',142);
insert into participe values ('CAN018',109);
insert into participe values ('CAN099',126);

insert into participe values ('SBER128',142);
insert into participe values ('SBER126',110);
insert into participe values ('MUF530',111);
insert into participe values ('MUF530',112);


insert into estClasse values ('CAN010',108,'1'); 
insert into estClasse values ('CAN013',145,'1'); 
insert into estClasse values ('CAN016',119,'1'); 
insert into estClasse values ('CAN017',125,'1');
insert into estClasse values ('CAN017',127,'1');
insert into estClasse values ('CAN019',111,'1');
insert into estClasse values ('CAN019',112,'3');
insert into estClasse values ('MUF530',111,'2');
insert into estClasse values ('MUF530',112,'2');

insert into estClasse values ('CAN017',109,'1'); 
insert into estClasse values ('CAN011',104,'1');
insert into estClasse values ('CAN019',142,'1');
insert into estClasse values ('SBER126',110,'1');
insert into estClasse values ('CA099',126,'1');


insert into vendu values (2,'CAN019',to_date('06/12/1990','DD/MM/YYYY'));
insert into vendu values (6,'LAB026',to_date('26/01/1998','DD/MM/YYYY'));
insert into vendu values (6,'LAB025',to_date('27/01/1998','DD/MM/YYYY'));
insert into vendu values (6,'LAB023',to_date('28/01/1998','DD/MM/YYYY'));
insert into vendu values (9,'LAB024',to_date('06/03/1999','DD/MM/YYYY'));
insert into vendu values (11,'GOL036',to_date('03/04/1996','DD/MM/YYYY'));
insert into vendu values (11,'GOL034',to_date('12/04/1996','DD/MM/YYYY' ));
insert into vendu values (11,'FOX041',to_date('08/09/1994','DD/MM/YYYY' ));
insert into vendu values (11,'FOX047',to_date('02/10/1994','DD/MM/YYYY') );
insert into vendu values (2,'FOX044',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (21,'SBER121',to_date('10/11/1956','DD/MM/YYYY'));
insert into vendu values (21,'SBER120',to_date('10/11/1956','DD/MM/YYYY'));
insert into vendu values (21,'SBER128',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (8,'SBER127',to_date('02/04/1998','DD/MM/YYYY'));
insert into vendu values (24,'SBER126',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (24,'SBER125',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (19,'GRI116',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (19,'GRI112',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (19,'GRI111',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (6,'GRI110',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (25,'EPA103',to_date('02/04/1999','DD/MM/YYYY'));
insert into vendu values (25,'EPA106',to_date('12/04/1999','DD/MM/YYYY'));
insert into vendu values (15,'EPA102',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (13,'MUF537',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (3,'MUF533',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (3,'MUF534',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (3,'MUF536',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (3,'MUF538',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (3,'MUF532',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (3,'MUF531',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (3,'MUF530',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (20,'DOB089',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (20,'DOB088',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (24,'DOB087',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (23,'DOB083',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (22,'DOB081',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (20,'DOB080',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (9,'BOUL061',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (11,'BER053',to_date('02/04/1997','DD/MM/YYYY'));
insert into vendu values (12,'BER055',to_date('02/04/1997','DD/MM/YYYY'));



insert into aPourParent values ('CAN010','CAN012'); 
insert into aPourParent values ('CAN010','CAN019');
insert into aPourParent values ('CAN019','CAN015'); 
insert into aPourParent values ('CAN019','CAN018');
insert into aPourParent values ('CAN012','CAN015');
insert into aPourParent values ('CAN012','CAN018'); 
insert into aPourParent values ('CAN017','CAN014');
insert into aPourParent values ('CAN017','CAN018');
insert into aPourParent values ('CAN013','CAN014');
insert into aPourParent values ('CAN013','CAN018');
insert into aPourParent values ('CAN001','CAN014');
insert into aPourParent values ('CAN001','CAN018');
insert into aPourParent values ('CAN099','CAN015'); 
insert into aPourParent values ('CAN099','CAN018');

insert into aPourParent values ('LAB024','LAB025'); 
insert into aPourParent values ('LAB024','LAB023'); 
insert into aPourParent values ('LAB023','LAB020'); 
insert into aPourParent values ('LAB023','LAB022');
insert into aPourParent values ('LAB025','LAB020');
insert into aPourParent values ('LAB025','LAB022');
insert into aPourParent values ('LAB026','LAB020');
insert into aPourParent values ('LAB026','LAB022');

insert into aPourParent values ('GOL033','GOL034');
insert into aPourParent values ('GOL033','GOL036');
insert into aPourParent values ('GOL034','GOL032');
insert into aPourParent values ('GOL034','GOL039');
insert into aPourParent values ('GOL036','GOL039');
insert into aPourParent values ('GOL036','GOL032');

insert into aPourParent values ('FOX044','FOX041');
insert into aPourParent values ('FOX044','FOX047');
insert into aPourParent values ('FOX041','FOX045');
insert into aPourParent values ('FOX041','FOX049');
insert into aPourParent values ('FOX047','FOX045');
insert into aPourParent values ('FOX047','FOX049');

insert into aPourParent values ('SBER120','SBER126');
insert into aPourParent values ('SBER121','SBER126');
insert into aPourParent values ('SBER127','SBER121');
insert into aPourParent values ('SBER128','SBER120');


insert into aPourParent values ('MUF530','MUF531');
insert into aPourParent values ('MUF530','MUF532');
insert into aPourParent values ('MUF531','MUF538');
insert into aPourParent values ('MUF531','MUF536');
insert into aPourParent values ('MUF532','MUF534');
insert into aPourParent values ('MUF532','MUF531');