1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
|
CREATE TABLE Region(
idRegion INTEGER NOT NULL,
nomRegion VARCHAR(50) NOT NULL,
CONSTRAINT Region_IdRegion_PK PRIMARY KEY (idRegion));
CREATE SEQUENCE seq_reg START WITH 1 INCREMENT BY 1;
INSERT INTO Region VALUES(seq_reg.NEXTVAL,'Grand Casablanca');
-----------------------------------------------
CREATE TABLE ProvincePrefecture(
IdProvPref INTEGER NOT NULL,
nomProvPref VARCHAR(50) NOT NULL,
idRegion INTEGER NOT NULL,
CONSTRAINT ProPref_IdProvPref_PK PRIMARY KEY (idProvPref),
CONSTRAINT ProPref_IdRegion_FG FOREIGN KEY (idRegion) REFERENCES Region(idRegion));
CREATE SEQUENCE seq_ProvPref START WITH 1 INCREMENT BY 1;
INSERT INTO ProvincePrefecture VALUES(seq_ProvPref.NEXTVAL, 'Prefecture de Casablanca',1);
-----------------------------------------------
CREATE TABLE TrancheAge(
idTranche INTEGER NOT NULL,
tranche VARCHAR(20) NOT NULL,
CONSTRAINT TrancheAge_idTranche_PK PRIMARY KEY (idTranche));
CREATE SEQUENCE seq_Tranche START WITH 1 INCREMENT BY 1;
INSERT INTO TrancheAge VALUES(seq_Tranche.NEXTVAL,'Entre 35 et 45 ans');
-----------------------------------------------
CREATE TABLE Circonscription(
idCirconscription INTEGER NOT NULL,
nomCir VARCHAR(20) NOT NULL,
NombreSiege INTEGER NOT NULL,
idProvPref INTEGER NOT NULL,
CONSTRAINT Circon_idCircon_PK PRIMARY KEY (idCirconscription),
CONSTRAINT Circon_idProvPref_FG FOREIGN KEY (idProvPref) REFERENCES ProvincePrefecture(idProvPref));
CREATE SEQUENCE seq_Circon START WITH 1 INCREMENT BY 1;
INSERT INTO Circonscription VALUES(seq_Circon.NEXTVAL,'Anfa',20,1);
-----------------------------------------------
CREATE TABLE Parti(
idParti INTEGER NOT NULL,
nomParti VARCHAR(20) NOT NULL,
CONSTRAINT Parti_idParti_PK PRIMARY KEY (idParti));
CREATE SEQUENCE seq_Parti START WITH 1 INCREMENT BY 1;
INSERT INTO Parti VALUES(seq_Parti.NEXTVAL,'Transport');
-----------------------------------------------
CREATE TABLE Candidat(
CINcandidat VARCHAR2(8) NOT NULL,
nomCandidat VARCHAR(10) NOT NULL,
prenomCandidat VARCHAR(10) NOT NULL,
DateNC DATE NOT NULL,
niveauScolaire VARCHAR(10) NOT NULL,
NumOrdreListe INTEGER NOT NULL,
adrCandidat VARCHAR2(100) NOT NULL,
idCirconscription INTEGER NOT NULL,
idParti INTEGER NOT NULL,
idTrancheAge INTEGER NOT NULL,
CONSTRAINT Candidat_CINCandidat_PK PRIMARY KEY (CINcandidat),
CONSTRAINT Candidat_idCirconscription_FG FOREIGN KEY (idCirconscription) REFERENCES Circonscription(idCirconscription),
CONSTRAINT Candidat_idParti_FG FOREIGN KEY (idParti) REFERENCES Parti(idParti),
CONSTRAINT Candidat_idTrancheAge_FG FOREIGN KEY (idTRancheAge) REFERENCES TrancheAge(idTranche));
INSERT INTO Candidat VALUES('BK389154','Lahlou','Youssef',to_date('26/06/14','dd/mm/yy'),'supérieur',1,'Cartier Anfa, BD biranZaran, rue Hafid Salafi App 6, App 1',1,1,1); |
Partager