Movie (MovieID, Title, Year, Score, Votes)

Actor(ActorID, Name)

Casting (MovieID, ActorID, Ordinal)

You need to create a le called views.sql, which is a text le containing your

views for each of the questions given below. Each view should be created

using a CREATE VIEW statement.

1. (15 points) The

KevinBacon

view is a table of the name of each actor

that has been cast in a movie with

Kevin Bacon

, along with a count

of the number of times they have been cast with Kevin Bacon.

3

2. (15 points) The

Popularity

view is a table of the ID, name, and

composite score of each actor. The composite score is the sum of the

score * votes for every movie the actor has been cast