CREATE TABLE Directors( 
    DirectorID INT PRIMARY KEY, 
    DirectorName VARCHAR(50)
    ); 

CREATE TABLE Movies( 
    MovieID INT PRIMARY KEY, 
    Title VARCHAR(50), 
    ReleaseYear VARCHAR(50), 
    MainCast VARCHAR(50), 
    Outcome VARCHAR(50)
    );

CREATE TABLE Actors(
   ActorID INT PRIMARY KEY, 
   ActorName VARCHAR(50), 
   DateOfBirth VARCHAR (50),
   MovieProjects VARCHAR(50),
   TVProjects VARCHAR(50)
); 

CREATE TABLE MovieProjects( 
    MovieID INT, 
    ActorID INT, 
    ReleaseYear INT, 
    
    FOREIGN KEY (ActorID)REFERENCES Actors(ActorID) ON DELETE ON CASCADE,
    FOREIGN KEY (MovieID)REFERENCES Movies(MovieID) ON DELETE ON CASCADE
);

CREATE TVProjects( 
    TVProjectsID INT, 
    ActorID INT, 
    Title VARCHAR(50) 
);


INSERT INTO Directors VALUES
    (1, 'Stephen Spielberg'), 
    (2, 'Martin Scorsese'), 
    (3, 'Christopher Nolan'), 
    (4, 'Quentin Tarantino'), 
    (5, 'Alfred Hitchcock'), 
    (6, 'Francis Ford Coppola'), 
    (7, 'James Cameron'), 
    (8, 'Ridley Scott'),
    (9, 'Peter Jackson'), 
    (10, 'David Fincher');


INSERT INTO Movies VALUES
    (1, 'Schindlers List', 1993, 'Liam Neeson, Ben Kingsley, Ralph Fiennes', '$322.2M'), 
    (2, 'GoodFellas', 1990, 'Robert De Niro, Ray Liotta, Joe Pesci', '$47.1M'),
    (3, 'Inception', 2010, 'Leonardo DiCaprio,Joseph Gordon-Levitt', '$839.4 M'),
    (4, 'Pulp Fiction', 1994, 'John Travolta, Uma Thurman , Samuel L. Jackson', '$213.9M'),
    (5, 'Psycho', 1960, 'Anthony Perkins, Janet Leigh, Vera Miles', '$32.2M'), 
    (6, 'The GodFather', 1972, 'Marlon Brando , Al Pacino, James Caan', '$250.3 M'), 
    (7,'Titanic', 1997, 'Leonardo DiCaprio, Kate Winslet', '$2.26 B'),
    (8, 'Gladiator', 2000, 'Russell Crowe, Joaquin Phoenix', '$465.5M'),
    (9,'The Lord Of The Rings: Return Of The King', 2003, 'Elijah Wood, Ian McKellen, Viggo Mortensen', '$1.14 B'),
    (10,'Fight Club', 2003, 'Brad Pitt, Edward Norton, Helena Bonham Carter', '$101.3M');

SELECT 
FROM Movies;