Database Of Movies Guide

INSERT INTO person (first_name, last_name) VALUES ('Christopher', 'Nolan'); INSERT INTO movie (title, release_date, runtime_minutes, budget, box_office_revenue) VALUES ('Inception', '2010-07-16', 148, 160000000, 836800000); INSERT INTO movie_director (movie_id, director_id) VALUES (1, 1); INSERT INTO genre (genre_name) VALUES ('Sci-Fi'), ('Thriller'); INSERT INTO movie_genre (movie_id, genre_id) VALUES (1,1), (1,2);

CREATE TABLE genre ( genre_id SERIAL PRIMARY KEY, genre_name VARCHAR(50) UNIQUE NOT NULL ); database of movies

CREATE TABLE movie_genre ( movie_id INT REFERENCES movie(movie_id) ON DELETE CASCADE, genre_id INT REFERENCES genre(genre_id) ON DELETE RESTRICT, PRIMARY KEY (movie_id, genre_id) ); INSERT INTO person (first_name

CREATE TABLE movie_director ( movie_id INT PRIMARY KEY REFERENCES movie(movie_id), director_id INT NOT NULL REFERENCES person(person_id) ); last_name) VALUES ('Christopher'

CREATE TABLE movie_cast ( movie_id INT REFERENCES movie(movie_id), actor_id INT REFERENCES person(person_id), character_name VARCHAR(150), PRIMARY KEY (movie_id, actor_id, character_name) );