Exercise 6.2.1: Using the database schema of our running movie example Movies (title, year, length, genre, studioName, producerC#) Stars In (movieTitle, movieYear, starName) MovieStar (name, address, gender, birthdate) MovieExec (name, address, cert#, netWorth) Studio (name, address, presC#) write the following queries in SQL. a) Who were the male stars in Titanic? b) Which stars appeared in movies produced by MGM in 1995? c) Who is the president of MGM studios? !d) Which movies are longer than Gone With the Wind? !e) Which executives are worth more than Merv Griffin?

Disclaimer: “Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts for you. To get the remaining sub-part solved please repost the complete question and mention the sub-parts to be solved.”. Introduction: A database schema specifies(defines) the logical restrictions, including table names, fields, data types, and the connections between these entities, that define how data is arranged in a relational database.Solution a) Query to find the Male star in Titanic: SELECT name FROM MovieStar WHERE gender = 'M' and name IN (SELECT starName FROM StarsIn WHERE movieTitle = 'Titanic'); Solution b) Query to find the query that displays stars in the movies produced by MGM in 1995: SELECT starName FROM Stars In WHERE movieTitle IN (SELECT title FROM Movies WHERE studioName = 'MGM' AND year = 1995);Solution C) Query to display the president of MGM studios: SELECT name FROM MovieExec WHERE cert# IN (SELECT presC# FROM Studio WHERE name = 'MGM');