DROP TABLE  Demandeur;
DROP TABLE Offre;
DROP TABLE Entreprise;

CREATE TABLE Entreprise (nume NUMBER PRIMARY KEY, nome VARCHAR(30), adre VARCHAR(30));
CREATE TABLE Offre (numo NUMBER PRIMARY KEY, nume NUMBER, contrat VARCHAR(20), qualif VARCHAR(20), salaire NUMBER, lieu VARCHAR(30),CONSTRAINT fk_nume FOREIGN KEY (nume) REFERENCES Entreprise(nume));
CREATE TABLE Demandeur (numd NUMBER PRIMARY KEY, nom VARCHAR(20), prenom VARCHAR(20), adresse VARCHAR(30), qualif VARCHAR(20), dateinscrip DATE);



INSERT INTO Entreprise VALUES (1,'CapGemini','Paris (FRANCE)');
INSERT INTO Entreprise VALUES (2,'IBM','Armonk, New York (USA)');
INSERT INTO Entreprise VALUES (3,'Atos Origin','Courbevoie (France)');
INSERT INTO Entreprise VALUES (4,'Dell','Round Rock, Texas (USA)');
INSERT INTO Entreprise VALUES (5,'Sopra Group','Paris (FRANCE)');
INSERT INTO Entreprise VALUES (6,'HP','Palo-Alto, Californie (USA)');

INSERT INTO Offre VALUES (1,1,'CDI','AdminSys',2000,'Toulouse');
INSERT INTO Offre VALUES (2,2,'Interim','Webmaster',1500,'Paris');
INSERT INTO Offre VALUES (3,3,'CDI','AdminBD',2100,'Lyon');
INSERT INTO Offre VALUES (4,5,'Interim','Consultant',2900,'Paris');
INSERT INTO Offre VALUES (5,5,'CDD','Consultant',3500,'Paris');
INSERT INTO Offre VALUES (6,2,'CDI','AdminBD',2400,'Toulouse');
INSERT INTO Offre VALUES (7,1,'Interim','Webmaster',1400,'Lille');
INSERT INTO Offre VALUES (8,4,'CDI','Developpeur',1600,'Toulouse');
INSERT INTO Offre VALUES (9,5,'CDD','AdminSys',1900,'Paris');
INSERT INTO Offre VALUES (10,2,'CDI','Developpeur',1700,'Toulouse');
INSERT INTO Offre VALUES (11,2,'CDD','Developpeur',2200,'Lyon');
INSERT INTO Offre VALUES (12,3,'Interim','Consultant',1250,'Lyon');
INSERT INTO Offre VALUES (13,5,'CDI','Developpeur',3000,'Paris');
INSERT INTO Offre VALUES (14,1,'CDI','AdminBD',2200,'Montpellier');
INSERT INTO Offre VALUES (15,1,'Interim','Consultant',1300,'Nancy');
INSERT INTO Offre VALUES (16,1,'CDI','Developpeur',1600,'Toulouse');


INSERT INTO Demandeur VALUES (1,'Dupont','Mathieu','Toulouse','Developpeur','09-09-2007');
INSERT INTO Demandeur VALUES (2,'Dalors','Homère','Lille','Developpeur','15-10-2007');
INSERT INTO Demandeur VALUES (3,'Kahl','Jean','Toulouse','AdminSys','11-12-2007');
INSERT INTO Demandeur VALUES (4,'Stal','Ingrid','Lille','Webmaster','26-12-2007');
INSERT INTO Demandeur VALUES (5,'Dupond','Matthieu','Paris','AdminBD','02-11-2007');
INSERT INTO Demandeur VALUES (6,'Cleub','Medhi','Paris','Webmaster','18-11-2007');
INSERT INTO Demandeur VALUES (7,'Tylo','Ivan','Lyon','Webmaster','13-07-2007');
INSERT INTO Demandeur VALUES (8,'Bathe','Anne','Nancy','Graphiste','07-11-2007');
INSERT INTO Demandeur VALUES (9,'Harem','Colette','Paris','AdminBD','21-11-2007');
INSERT INTO Demandeur VALUES (10,'Manfaud','Gérard','Toulouse','Consultant','30-06-2007');