2ZiGtCS6

1DROP TABLE IF EXISTS Genre;
2CREATE TABLE Genre (
3  ID_Genre INTEGER PRIMARY KEY, 
4  Genre VARCHAR(30)
5);
6
7DROP TABLE IF EXISTS Individu;
8CREATE TABLE Individu (
9  Num_Ind INTEGER PRIMARY KEY, 
10  Nom VARCHAR(20), 
11  Prenom VARCHAR(20)
12);
13
14DROP TABLE IF EXISTS Cinema;
15CREATE TABLE Cinema (
16  Num_Cine INTEGER PRIMARY KEY, 
17  Nom VARCHAR(20), 
18  Adresse VARCHAR(50)
19);
20
21DROP TABLE IF EXISTS Jouer;
22CREATE TABLE Jouer (
23  Num_Ind INTEGER,
24  Num_Film INTEGER, 
25  Alias VARCHAR(30),
26  CONSTRAINT PRIMARY KEY (Num_Ind, Num_Film)
27);
28
29DROP TABLE IF EXISTS Film;
30CREATE TABLE Film (
31  Num_Film INTEGER PRIMARY KEY, 
32  Titre VARCHAR(100), 
33  ID_Genre INTEGER, 
34  Année INTEGER
35);
36
37DROP TABLE IF EXISTS Projection;
38CREATE TABLE Projection (
39  Num_Cine INTEGER,
40  Num_Film INTEGER,
41  Date_Projection DATETIME NOT NULL,
42  CONSTRAINT PRIMARY KEY (Num_Cine,Num_Film,Date_Projection)
43);
44
45ALTER TABLE Cinema
46ADD FOREIGN KEY (Num_Cine) REFERENCES Projection(Num_Cine);
47
48ALTER TABLE Jouer
49ADD FOREIGN KEY (Num_Film) REFERENCES Film(Num_Film);
50
51ALTER TABLE Film
52ADD FOREIGN KEY (ID_Genre) REFERENCES Genre(ID_Genre);
53
54ALTER TABLE Projection
55ADD FOREIGN KEY (Num_Cine) REFERENCES Cinema(Num_Cine);