Question

Consider the data model below for movies, music, and sound tracks. Note that each movie has a theme song/music in the movie sound track. Answer the questions using the data model described below. Assumption: each movie has a unique theme song. MUSIC SOUNDTRACK MOVIE *Song ID, Directo QriginalSinger Date of Composition Duration

Q5. How many movies have more than 10 songs in their sound track? Provide the title and the director of these movies. Using SQL

Answer 1

/*Music(SongID*, SongName, MainComposer, OriginalSinger, DateOfComposition, Duration);
Movie(MovieTitle*, M_ReleaseDate*, Movie_Director, M_TotalRevenue);
SoundTrack(*SongID, *MovieTitle, *M_ReleaseDate)

How many movies have more than 10 songs in their sound track? Provide the title and the
director of these movies. Using SQL.*/

SELECT MovieTitle, MovieDirector FROM Music Mu, Movie Mv, SoundTrack ST
WHERE ST.SongID = Mu.SongID
AND Mv.MovieTitle = ST.MovieTitle
AND Mv.M_ReleaseDate = ST.M_ReleaseDate
GROUP BY Mv.MovieTitle, Mv.M_ReleaseDate
HAVING COUNT(*) > 10