Corrigés des exercices - UML 2: Pour les bases de donnees - page 291

Script SQL ( suite )

CREATE TABLE carte (
code_idelite NUMBER(1) NOT NULL,
lib_idelite VARCHAR2(20),
CONSTRAINT pk_carte
PRIMARY KEY (code_idelite));

CREATE INDEX reserver_fk ON place
(num_carte ASC);

CREATE INDEX depart_fk ON vol
(code_oaci_dep ASC);

CREATE TABLE passager (
num_carte NUMBER(12) NOT NULL,
code_idelite NUMBER(1),
nom_client VARCHAR2(40),
prenom_client VARCHAR2(40),
CONSTRAINT pk_passager
PRIMARY KEY (num_carte));

CREATE INDEX arrivee_fk ON vol
(code_oaci_arr ASC);

CREATE INDEX constituer_fk ON
volreel (num_vol ASC);

CREATE INDEX planning_fk ON
planning (num_vol ASC);

CREATE TABLE place (
num_vol VARCHAR2(8) NOT NULL,
jour_mois VARCHAR2(6) NOT NULL,
num_siege VARCHAR2(3) NOT NULL,
num_carte NUMBER(12) NOT NULL,
CONSTRAINT pk_place
PRIMARY KEY (num_vol,
jour_mois,num_siege));

CREATE TABLE vol (
num_vol VARCHAR2(8) NOT NULL,
code_oaci_dep VARCHAR2(4) NOT NULL,
code_oaci_arr VARCHAR2(4) NOT NULL,
heure_dep NUMBER(2) NOT NULL,
heure_emb NUMBER(2) NOT NULL,
heure_arriv NUMBER(2) NOT NULL,
min_emb NUMBER(2) NOT NULL,
min_dep NUMBER(2) NOT NULL,
min_arr NUMBER(2) NOT NULL,
CONSTRAINT pk_vol
PRIMARY KEY (num_vol));