SQL language

A movie may have many actors, and an actor can act in many movies. An actor can play more than one role in the same movie Suppose we try to represent this in our database using an Actor table, a Movie table, and a Role table. The Role table has a foreign key to reference the Actor table, plus the name of the role and the title of the movie. What could go wrong with this? The actor referenced might not exist in the table There might be actors who do not have roles in the Role table A role might list a movie title that does not exist in the Movie table There could be more than one actor with the same name