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 72 73 74 75
| */
ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY';
ALTER SESSION SET NLS_DATE_LANGUAGE='ENGLISH';
/* Destruction eventuelle des tables existantes */
/* Creation des tables */
drop table Internaute CASCADE CONSTRAINTS;
drop table Pays CASCADE CONSTRAINTS ;
rem drop table Artiste CASCADE CONSTRAINTS ;
rem drop table Film CASCADE CONSTRAINTS ;
rem drop table Notation CASCADE CONSTRAINTS ;
rem drop table Role CASCADE CONSTRAINTS ;
drop table Genre CASCADE CONSTRAINTS ;
CREATE TABLE Internaute (email VARCHAR2(40) Constraint pk_Internaute primary key,
nomI VARCHAR2(30) constraint nl_Internaute_nomI NOT NULL ,
prenomI VARCHAR2(30) constraint nl_Internaute_prenomI NOT NULL,
region VARCHAR2(30) constraint nl_Internaute_region NOT NULL
);
CREATE TABLE Pays (code VARCHAR2(4) Constraint pk_Pays primary key,
nomP VARCHAR2 (30) DEFAULT 'Inconnu' ,
langue VARCHAR2(30) Constraint nl_Pays_langue NOT NULL
);
CREATE TABLE Artiste (numartist number(4) Constraint pk_Artiste primary key ,
nomA VARCHAR2 (30) constraint nl_Artiste_nomA NOT NULL
prenomA VARCHAR2(30) constraint nl_Artiste_nomA NOT NULL ,
anneeNaissA number(4) constraint nl_Artiste_anneeNaissA NOT NULL
);
CREATE TABLE Film (numf number(4) Constraint pk_Film primary key ,
titre VARCHAR2(50) Constraint nl_Film_titre NOT NULL,
annee number(4) Constraint nl_Film_annee NOT NULL,
idMES number(4) Constraint nl_Film_idMES NOT NULL,
genre VARCHAR2 (20) Constraint nl_Film_genre NOT NULL,
resume varchar2(2000) Constraint nl_Film_resume NOT NULL,
codePays VARCHAR2(4) Constraint nl_Film_codePays Not null ,
Constraint fk_Film_Artiste FOREIGN KEY (idMES) REFERENCES Artiste(numartist),
Constraint fk_Film_Pays FOREIGN KEY (codePays) REFERENCES Pays(code)
);
CREATE TABLE Notation (numf number(4) ,
email VARCHAR2 (40) ,
note number(4) CONSTRAINT nl_Notation_note NOT NULL ,
CONSTRAINT pk_Notation PRIMARY KEY (numf, email)
);
CREATE TABLE Role (idF number(4) ,
numartist Number(4) ,
nomRole VARCHAR2(30) ,
CONSTRAINT pk_Role PRIMARY KEY (idActeur,numf),
CONSTRAINT fk_Role_Film FOREIGN KEY (idF) REFERENCES Film(numf),
CONSTRAINT fk_Role_Artiste FOREIGN KEY (numartist) REFERENCES Artiste(numartist)
);
CREATE TABLE Genre (code VARCHAR2(20) CONSTRAINT pk_Genre PRIMARY KEY
); |
Partager