SUBJECT: postgreSQL 1. Create a stored procedure where you can input a movie tit

Question

SUBJECT: postgreSQL

1. Create a stored procedure where you can input a movie title or actor’s name you like, and it will return the top five suggestions based on either movies the actor has starred in or films with similar genres.

2. Expand the movies database to track user comments and extract keywords (minus English stopwords). Cross-reference these keywords with actors’ last names, and try to find the most talked about actors.

I am a beginner at postgreSQL so please use simple code in order to solve these 2, not too complex.

THANK YOU SO MUCH IN ADVANCE

Explanation / Answer

OR

Note: Assuming movie_actor is the table and actor_name and movie_genre are its attributes/columns.

2)

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.