CREATE DATABASE products; CREATE TABLE products ( id INT NOT NULL AUTO_INCREMENT, nom VARCHAR(255) NOT NULL, price INT NOT NULL, idGenre INT, realisateur VARCHAR(255), annee INT, musique VARCHAR(255), scenario VARCHAR(255), PRIMARY KEY (id)); CREATE TABLE genre ( id INT NOT NULL AUTO_INCREMENT, nom VARCHAR(255) NOT NULL, PRIMARY KEY (id)); alter table products add constraint FKPRODUCTS1 foreign key (idGenre) references genre(id); INSERT INTO genre (nom) VALUES ('Aventure'); INSERT INTO genre (nom) VALUES ('Policier'); INSERT INTO genre (nom) VALUES ('Comedie'); INSERT INTO genre (nom) VALUES ('Drame'); INSERT INTO genre (nom) VALUES ('Fantastique'); INSERT INTO genre (nom) VALUES ('Film d''animation'); INSERT INTO genre (nom) VALUES ('Action'); INSERT INTO genre (nom) VALUES ('Guerre'); INSERT INTO genre (nom) VALUES ('Documentaire'); INSERT INTO genre (nom) VALUES ('Suspense'); INSERT INTO products (nom, price, idGenre) values ('The Big Lebowsky', 15, 3); INSERT INTO products (nom, price, idGenre) values ('L''enfer du dimanche', 10, 1); INSERT INTO products (nom, price, idGenre) values ('American Beauty', 15, 4); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Vercingetorix', 15, 1, 'Jack Dorfmann', 2001); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Animal Factory', 15, 2, 'Steve Buscemi', 2000); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('La vie, l''amour, les vaches', 15, 3, 'Ron Underwood', 1991); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Crossing Guard', 15, 4, 'Sean Penn', 1995); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Tigres et dragons', 15, 1, 'Ang Lee', 2000); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Swimming with sharks', 25, 4, 'G. Huang', 1995); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Sling Blade', 20, 4, 'Billy Bob Thornton', 1997); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Magnolia', 20, 4, 'Paul Thomas Anderson', 1999); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Exit', 20, 2, 'Olivier Megaton', 2000); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('X-Men', 20, 5, 'Bryan Singer', 2000); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('The Yards', 25, 2, 'James Gray', 2000); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('O''Brother', 25, 3, 'Joel Cohen, Ethan Cohen', 2000); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Les mutants de l''espace', 15, 6, 'Bill Plympton', 2001); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('High Fidelity', 10, 3, 'Stephen Frears', 2000); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Trainspotting', 10, 4, 'Danny Boyle', 1996); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Predator 2', 10, 5, 'Stephen Hopkins', 1990); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Une affaire de gout', 15, 4, 'Bernard Rapp', 1999); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Cecil B. DeMented', 25, 3, 'John Waters', 2000); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Abyss', 25, 5, 'James Cameron', 1989); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Ghost World', 15, 3, 'Terry Zwigoff', 2001); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Les Autres', 20, 5, 'Alejandro Amenabar', 2001); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('The Big One', 20, 9, 'Michael Moore', 1999); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Ocean''s Eleven', 15, 10, 'Steven Soderbergh', 2001); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('La rancon', 15, 10, 'Ron Howard', 1996); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('La plage', 15, 1, 'Danny Boyle', 1999); INSERT INTO products (nom, price, idGenre, realisateur, annee) values ('Barton Fink', 15, 4, 'Joel et Ethan Cohen', 1991); INSERT INTO products (nom, price, idGenre, realisateur, annee, musique, scenario) values ('Braveheart', 15, 1, 'Mel Gibson', 1995, 'James Horner', 'Randall Wallace'); INSERT INTO products (nom, price, idGenre, realisateur, annee, musique, scenario) values ('Les grands ducs', 20, 3, 'Patrice Leconte', 1995, 'Jean-Claude Nachon, Angelique Nachon', 'Patrice Leconte, S. Frydman'); INSERT INTO products (nom, price, idGenre, realisateur, annee, musique, scenario) values ('La ligne Verte', 10, 4, 'Frank Darambont', 1999, 'Thomas Newman', 'Frank Darambont'); INSERT INTO products (nom, price, idGenre, realisateur, annee, musique, scenario) values ('Fist of Legend', 15, 7, 'Gordon Chan', 1994, 'Joseph Koo', 'Gordon Chan, Lan Kay Toa'); INSERT INTO products (nom, price, idGenre, realisateur, annee, musique, scenario) values ('En territoire ennemi', 20, 8, 'John Moore', 2001, 'Don Davis', 'Jim Thomas, John Thomas, David Veloz, Zak Penn'); INSERT INTO products (nom, price, idGenre, realisateur, annee, musique, scenario) values ('Monique', 25, 3, 'Valerie Guignabodet', 2002, 'Cedric Neveux', 'Valerie Guignabodet'); INSERT INTO products (nom, price, idGenre, realisateur, annee, musique, scenario) values ('Little Buddha', 15, 4, 'Bernardo Bertolucci', 1993, 'Ryuichi Sakamoto', 'Bernardo Bertolucci, Mark Peploe');