

Drop table PROD1;
Drop table PROD2;
Drop table E1;
Drop table E2;
Drop table MAG;
Drop table VENTES;

Create table PROD1(NP1 integer, DESCR1 char(10),  PRIX1 integer);
Create table PROD2(NP2 integer, DESCR2 char(10),  PRIX2 integer);

Create table E1(NE integer, NOM char(10), ADR char(10), RAYON integer);
Create table E2(NE integer, DEB date, FIN date, SALAIRE integer);

Create table MAG(RAYON integer, ETAGE integer,   DIR integer);
Create table VENTES(NP integer, RAYON integer);


Insert into PROD1 values (0, 'CherEtNul',50);

Insert into PROD1 values (1, 'savon',10);
Insert into PROD1 values (2, 'savon',2);
Insert into PROD1 values (3, 'savon',7);
Insert into PROD1 values (4, 'savon',15);
Insert into PROD1 values (5, 'savon',6);

Insert into PROD1 values (6, 'shampoing',1);
Insert into PROD1 values (7, 'shampoing',20);
Insert into PROD1 values (8, 'shampoing',5);
Insert into PROD1 values (9, 'shampoing',10);
Insert into PROD1 values (10, 'shampoing',7);

Insert into PROD1 values (11, 'lessive',25);
Insert into PROD1 values (12, 'lessive',34);
Insert into PROD1 values (13, 'lessive',31);

Insert into PROD1 values (14, 'serviette',100);
Insert into PROD1 values (15, 'serviette',22);
Insert into PROD1 values (16, 'serviette',35);
Insert into PROD1 values (17, 'serviette',41);
Insert into PROD1 values (18, 'serviette',58);
Insert into PROD1 values (19, 'serviette',64);
Insert into PROD1 values (20, 'serviette',82);

Insert into PROD1 values (21, 'torchon',10);
Insert into PROD1 values (22, 'torchon',26);
Insert into PROD1 values (23, 'torchon',101);
Insert into PROD1 values (24, 'torchon',12);
Insert into PROD1 values (25, 'torchon',82);
Insert into PROD2 values (25, 'torchon',82);

Insert into PROD1 values (26, 'crayon',12);
Insert into PROD2 values (26, 'crayon',12);
Insert into PROD2 values (27, 'crayon',25);
Insert into PROD2 values (28, 'crayon',150);
Insert into PROD2 values (29, 'crayon',36);
Insert into PROD2 values (30, 'crayon',27);
Insert into PROD2 values (31, 'crayon',16);

Insert into PROD2 values (32, 'ciseaux',14);
Insert into PROD2 values (33, 'ciseaux',16);
Insert into PROD2 values (34, 'ciseaux',10);
Insert into PROD2 values (35, 'ciseaux',9);

Insert into PROD2 values (36, 'verre',10);
Insert into PROD2 values (37, 'verre',18);
Insert into PROD2 values (38, 'verre',156);
Insert into PROD2 values (39, 'verre',36);
Insert into PROD2 values (40, 'verre',78);

Insert into PROD2 values (41, 'tasse',15);
Insert into PROD2 values (42, 'tasse',160);
Insert into PROD2 values (43, 'tasse',35);

Insert into PROD2 values (44, 'mouchoir',120);
Insert into PROD2 values (45, 'mouchoir',64);
Insert into PROD2 values (46, 'mouchoir',136);

Insert into PROD2 values (47, 'cahier',25);
Insert into PROD2 values (48, 'cahier',76);
Insert into PROD2 values (49, 'cahier',153);
Insert into PROD2 values (50, 'cahier',81);









Insert into E1 values (1,'dupont', 'Paris', 1);
Insert into E1 values (8,'durant','Lyon', 2);
Insert into E1 values (21,'duschmoll','GRENOBLE', 3);
Insert into E1 values (41,'pasqual', 'Marseille', 4);
Insert into E1 values (49,'martin', 'Saint Martin d"heres', 5);
Insert into E1 values (56,'benatar', 'Echirolles', 1);
Insert into E1 values (61,'satriani', 'Rennes', 2);
Insert into E1 values (73,'jordan', 'Toulouse', 3);
Insert into E1 values (82,'oldfield','Rouen', 4);
Insert into E1 values (101,'plisson', 'Tours', 5);
Insert into E1 values (111,'pichon', 'Strasbourg', 1);
Insert into E1 values (161,'poutou', 'Gap', 2);
Insert into E1 values (213,'tellier', 'Nice', 3);
Insert into E1 values (220,'thureau', 'Montpellier', 4);
Insert into E1 values (223,'thielan', 'Bordeau', 5);
Insert into E1 values (235,'tarel', 'Caen', 1);
Insert into E1 values (236,'toto', 'Caen', 1);
Insert into E1 values (237,'Solitaire', 'Nulpart', 6);



Insert into E2 values (257,'10-FEB-84', '01-JAN-94',1000);
Insert into E2 values (1,'10-FEB-84', '01-JAN-94',1000);
Insert into E2 values (1,'01-JAN-94', null, 1400);
Insert into E2 values (8,'01-JAN-92', '31-DEC-02',1800);
Insert into E2 values (8,'31-DEC-02',null,1900);
Insert into E2 values (21,'23-JUN-02', null, 2100);
Insert into E2 values (41,'10-MAY-86', '31-JUL-03', 1200);
Insert into E2 values (41,'31-JUL-03', null,1400);
Insert into E2 values (49,'10-FEB-82', '31-DEC-02', 1500);
Insert into E2 values (49,'31-DEC-02', null,1600);
Insert into E2 values (56,'10-FEB-83', '31-NOV-02', 1800);
Insert into E2 values (56, '31-NOV-02', null,2000);
Insert into E2 values (61,'11-JAN-81', '31-DEC-91', 1700);
Insert into E2 values (61,'31-DEC-91', '31-DEC-01',1800);
Insert into E2 values (61,'31-DEC-01',null,1800);
Insert into E2 values (73,'11-JAN-02', null, 2200);
Insert into E2 values (82,'12-JUN-91', '31-DEC-01', 3000);
Insert into E2 values (82, '31-DEC-01', null,3100);
Insert into E2 values (101,'10-JUN-02', null, 1300);
Insert into E2 values (111,'11-FEB-02', null, 1400);
Insert into E2 values (161,'12-OCT-91', '31-DEC-01', 2100);
Insert into E2 values (161,'31-DEC-01', null,2100);
Insert into E2 values (213,'10-FEB-00', null, 1000);
Insert into E2 values (220,'25-MAY-81', '31-DEC-91', 1200);
Insert into E2 values (220,'31-DEC-91', '31-DEC-01',1500);
Insert into E2 values (220,'31-DEC-01',null,1800);
Insert into E2 values (223,'30-DEC-95', null, 1800);
Insert into E2 values (235,'21-JAN-01', '31-DEC-02', 1800);
Insert into E2 values (235,'31-DEC-02', null,2000);

Insert into MAG values (1,1,1);
Insert into MAG values (2,3,61);
Insert into MAG values (2,4,61);
Insert into MAG values (3,5,213);
Insert into MAG values (3,6,213);
Insert into MAG values (4,7, 82);
Insert into MAG values (5,2,101);
Insert into MAG values (6,2,1000);
Insert into MAG values (300, 5, 61);

Insert into VENTES values (1, 2);
Insert into VENTES values (2, 2);
Insert into VENTES values (3, 2);
Insert into VENTES values (4, 3);
Insert into VENTES values (5, 1);

Insert into VENTES values (6, 1);
Insert into VENTES values (7, 4);
Insert into VENTES values (8, 5);
Insert into VENTES values (9, 3);
Insert into VENTES values (10, 2);

Insert into VENTES values (11, 1);
Insert into VENTES values (12, 4);
Insert into VENTES values (13, 1);

Insert into VENTES values (14, 3);
Insert into VENTES values (15, 2);
Insert into VENTES values (16, 5);
Insert into VENTES values (17, 1);
Insert into VENTES values (18, 3);
Insert into VENTES values (19, 4);
Insert into VENTES values (20, 2);

Insert into VENTES values (21, 3);
Insert into VENTES values (22, 2);
Insert into VENTES values (23, 1);
Insert into VENTES values (24, 5);
Insert into VENTES values (25, 2);

Insert into VENTES values (26, 2);
Insert into VENTES values (27, 5);
Insert into VENTES values (28, 4);
Insert into VENTES values (29, 1);
Insert into VENTES values (30, 2);
Insert into VENTES values (31, 1);

Insert into VENTES values (32, 4);
Insert into VENTES values (33, 1);
Insert into VENTES values (34, 3);
Insert into VENTES values (35, 4);

Insert into VENTES values (36, 3);
Insert into VENTES values (37, 1);
Insert into VENTES values (38, 1);
Insert into VENTES values (39, 1);
Insert into VENTES values (40, 3);

Insert into VENTES values (41, 1);
Insert into VENTES values (42, 3);
Insert into VENTES values (43, 5);

Insert into VENTES values (44, 3);
Insert into VENTES values (45, 4);
Insert into VENTES values (46, 1);

Insert into VENTES values (47, 5);
Insert into VENTES values (48, 1);
Insert into VENTES values (49, 3);
Insert into VENTES values (50, 1);
Insert into VENTES values (60, 100);
Insert into VENTES values (600, 1);


