Your answers seem right.

I need help with some of my queries. I have done some but these are complex queries for me.

Find the movieID, title, and year, and the roleID and roleName in the join between the Movie and Role tables where the value of movieID is the same in both.

Find the roleID, quoteID, and quoteID in the join between the Quote and RoleQuote tables where the value of quoteID is the same in both.

Find all columns of the Cartesian product of the Movie and Role tables.

Find all columns of the Cartesian product of the Quote and RoleQuote tables.

My answers:

Select Movie.movieID, title, year, roleID, roleName From Movie, Role WHERE Movie.movieID = Role.movieID;



Select Quote.quoteID, roleID From Quote, RoleQuote WHERE Quote.quoteID = RoleQuote.quoteID;



Select * From Movie, Role;



Select * From Quote, RoleQuote;