Post your solutions to the Nov 20 In-Class Exercise to this thread.

Best,

Chris

CREATE VIEW StarMovies(movieTitle, movieYear, movieStarName) AS SELECT title, year, movieStarName FROM Movies, StarsIn WHERE movieTitle = title AND movieYear = year;

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, starName FROM Movies, StarsIn WHERE title=movieTitle AND year=movieYear;

CREATE VIEW StarMovies(title, year, starName) AS SELECT title, year, starName FROM StarsIn WHERE StarsIn.title=title AND StarsIn.year = year;

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, MovieStar.name FROM Movies, StarsIn, MovieStar WHERE StarsIn.movie = Movies.title AND StarsIn.year = Movies.year AND StarsIn.starName = MovieStar.name

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT movieTitle, movieYear, starName FROM StarsIn WHERE true;

CREATE VIEW StarMovies(title, year, movieStarName) AS (SELECT * FROM StarsIn);

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, movieStarName FROM (Movies NATURAL JOIN StarsIn)

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, starName FROM Movies, StarsIn WHERE title = Movies.title AND year = Movies.year;

CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, name FROM Movies, StarsIn WHERE title=movieTitle AND name=starName