CREATE TABLE IF NOT EXISTS FILMS
(id INT, titre TEXT, id_realisateur INT, annee INT, note_critique TEXT,
PRIMARY KEY(id), FOREIGN KEY(id_realisateur) REFERENCES REALISATEURS(id));

CREATE TABLE IF NOT EXISTS REALISATEURS
(id INT, realisateur TEXT, annee_naissance INT, pays TEXT,
PRIMARY KEY(id));

DELETE FROM FILMS;
INSERT INTO FILMS VALUES
(1, "Terminator", 1, 1974, "****"),
(2, "Titanic", 1, 1997, "***"),
(3, "Avatar", 1, 2009, "****"),
(4, "Avatar 2", 1, 2022, "***"),
(5, "Avatar 3", 1, 2024, "?"),
(6, "E.T.", 2, 1982, "**"),
(7, "Jurassic Park", 2, 1993, "****"),
(8, "Docteur Folamour", 3, 1964, "**"),
(9, "2001", 3, 1964, "**"),
(10, "Eyes Wide Shut", 3, 1999, "*"),
(11, "Memento", 4, 2000, "**"),
(12, "Interstellar", 4, 2014, "****"),
(13, "Je vous salue, Marie", 5, 1985, "*"),
(14, "Nouvelle vague", 5, 1990, "***");

DELETE FROM REALISATEURS;
INSERT INTO REALISATEURS VALUES
(1, "Cameron", 1954, "Canada"),
(2, "Spielberg", 1946, "USA"),
(3, "Kubrick", 1928, "USA"),
(4, "Nolan", 1970, "UK/USA"),
(5, "Godard", 1930, "France/Suisse");