-
Sharda Mundotiya
- Student
925 Views
0 Comments
This is a movie graph database. Which contains different movies and their information like: movie genre, movie director, Producer, writer, Actors, name, id etc. Different arrows indicates different relations. Your task is to create movie graph database and solve the graph queries:
Query 1: Find the movies under "Action" genre and rated "PG-13" or’ PG’.Output the movie titles only.
Query2: Find the cast of "The Matrix Movie”.
Query3: Find the most prolific directors. For each director with more than 2 movies, output the name, movies directed as collection, and the total number of movies directed.
Query4: Find the movies (as a collection) directed by the same directors of "The Matrix".
Query5: Find all movies in which Morgan Freeman appeared. For each movie, output its title, genre as a collection, cast as a collection, rating, and Morgan Freeman's role in that movie.
Query 1: Find the movies under "Action" genre and rated "PG-13" or’ PG’.Output the movie titles only.
Query2: Find the cast of "The Matrix Movie”.
Query3: Find the most prolific directors. For each director with more than 2 movies, output the name, movies directed as collection, and the total number of movies directed.
Query4: Find the movies (as a collection) directed by the same directors of "The Matrix".
Query5: Find all movies in which Morgan Freeman appeared. For each movie, output its title, genre as a collection, cast as a collection, rating, and Morgan Freeman's role in that movie.
-
- Social Share
for this Blog
- Social Share
-
Comment
Porfolio And Blogs
Sharda Mundotiya follows various companies, these companies and employers can view Sharda's resume.
