Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- TP 1 CIRQUE --
- create table joue(nom char(15) ,role char(15) not null,titre char(20));
- create table numero(titre char(20),nature char(12),responsable char(15));
- create table accessoire (nomaccessoire char(22),couleur char(8),volume float,nocamion int,noratelier int);
- create table utilise(titredenumero char(20),nom char(15),nomaccessoire char(22));
- create table membre(nom char(15));
- insert into membre values('Clovis');
- insert into membre values('Reine de May');
- insert into membre values('Louche');
- insert into membre values('Attention');
- insert into membre values('Partition');
- insert into membre values('Moucheducoche');
- insert into membre values('Crinière');
- insert into membre values('Jerry');
- insert into membre values('Bal');
- insert into membre values('Final');
- insert into membre values('Louis');
- insert into membre values('Leo');
- insert into membre values('Lulu');
- insert into membre values('Coloquinte');
- insert into membre values('Grostas');
- insert into membre values('Sangtrespur');
- insert into numero values('Les Zoupalas','jonglerie','Clovis');
- insert into numero values('Le Coche Infernal','equitation','Reine de May');
- insert into numero values('Les Fauves','clownerie','Louche');
- insert into numero values('Les Smilers','equilibre','Attention');
- insert into numero values('La Passoire magique','dressage','Crinière');
- insert into numero values('Les Zozos','clownerie','Jerry');
- insert into numero values('Les Tartarins','jonglerie','Bal');
- insert into joue values ('Clovis','jongleur','Les Tartarins');
- insert into joue values ('Reine de May','ecuyer','Le Coche Infernal');
- insert into joue values ('Louche','clown','Les Zozos');
- insert into joue values ('Attention','equilibriste','Les Smilers');
- insert into joue values ('Partition','musicien','Les Tartarins');
- insert into joue values ('Crinière','dompteur','La Passoire magique');
- insert into joue values ('Jerry','clown','Les Zozos');
- insert into joue values ('Jerry','musicien','Les Fauves');
- insert into joue values ('Bal','jongleur','Les Fauves');
- insert into joue values ('Final','musicien','Les Tartarins');
- insert into joue values ('Louis','jongleur','Les Zoupalas');
- insert into joue values ('Leo','jongleur','Les Zoupalas');
- insert into joue values ('Lulu','ecuyer','Le Coche Infernal');
- insert into joue values ('Coloquinte','equilibriste','Les Smilers');
- insert into joue values ('Grostas','musicien','Les Zozos');
- insert into joue values ('Grostas','jongleur','Le Coche Infernal');
- insert into joue values ('Sangtrespur','dompteur','La Passoire magique');
- insert into joue values ('Sangtrespur','ecuyer','Le Coche Infernal');
- insert into joue values ('Grostas','jongleur','Les Tartarins');
- insert into accessoire values('ballon','rouge',0.3,5,15);
- insert into accessoire values('barre','blanc',0.6,5,19);
- insert into accessoire values('fouet','marron',0.2,3,11);
- insert into accessoire values('bicyclette','vert',0.4,8,27);
- insert into accessoire values('trompette','rouge',0.2,1,2);
- insert into accessoire values('cercle magique','orange',0.2,1,1);
- insert into accessoire values('boule','cristal',0.2,8,8);
- insert into accessoire values('etrier','noir',0.2,3,3);
- insert into accessoire values('tambour','bleu',0.4,3,2);
- insert into accessoire values('cage a lions','noir',10.1,2,0);
- insert into accessoire values('chaise longue de lion','bleu',0.9,5,11);
- insert into accessoire values('peigne de chimpanze','jaune',0.2,3,2);
- insert into accessoire values('balle','jaune',0.1,4,15);
- insert into accessoire values('corde','ocre',0.4,3,10);
- insert into accessoire values('trapèze','marron',0.7,7,11);
- insert into accessoire values('perruque','rouge',0.3,6,15);
- insert into utilise values('Les Zoupalas','Louis','ballon');
- insert into utilise values('Les Zoupalas','Leo','ballon');
- insert into utilise values('Les Zoupalas','Louis','barre');
- insert into utilise values('Le Coche Infernal','Grostas','balle');
- insert into utilise values('Le Coche Infernal','Sangtrespur','etrier');
- insert into utilise values('Le Coche Infernal','Lulu','fouet');
- insert into utilise values('Les Fauves','Jerry','trompette');
- insert into utilise values('Les Smilers','Attention','cercle magique');
- insert into utilise values('Les Smilers','Attention','boule');
- insert into utilise values('Les Smilers','Coloquinte','bicyclette');
- insert into utilise values('La Passoire magique','Crinière','cage a lions');
- insert into utilise values('La Passoire magique','Crinière','chaise longue de lion');
- insert into utilise values('Les Zozos','Jerry','bicyclette');
- insert into utilise values('Les Zozos','Jerry','peigne de chimpanze');
- insert into utilise values('Les Tartarins','Grostas','bicyclette');
- insert into utilise values('Les Tartarins','Partition','tambour');
- insert into utilise values('Les Zozos','Grostas','trompette');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement