Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE cinema;
- USE cinema;
- CREATE TABLE realisateurs(nomR VARCHAR(30) NOT NULL PRIMARY KEY, prenom VARCHAR(30),nationalite VARCHAR(40));
- CREATE TABLE acteurs(prenom VARCHAR(30), nomA VARCHAR(30) NOT NULL PRIMARY KEY,sexe CHAR,nationalite VARCHAR(50));
- CREATE TABLE Film(idF INT NOT NULL AUTO_INCREMENT PRIMARY KEY, nomR VARCHAR(30), genre VARCHAR(45), annee INT, entrees BIGINT);
- ALTER TABLE Film ADD FOREIGN KEY (nomR) REFERENCES realisateurs(nomR);
- CREATE TABLE distribution(idF INT, nomA VARCHAR(30));
- ALTER TABLE distribution ADD FOREIGN KEY (idF) REFERENCES Film(idF);
- ALTER TABLE distribution ADD FOREIGN KEY (nomA) REFERENCES acteurs(nomA);
- ALTER TABLE distribution ADD PRIMARY KEY (idF,nomA);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement