For this assignment, I plan to collect ratings for six popular movies from at least five people. Each person will rate the movies they have seen on a scale from 1 to 5. I plan to use PostgreSQL to store the collected data and R to load and analyze the ratings.
I plan to organize the database using separate tables for users, movies, and ratings. The ratings table will connect each user with the movies they rated. If someone has not seen a movie, I will treat the rating as missing rather than giving it a value of zero.
After storing the ratings in PostgreSQL, I will load the data into R as a dataframe and perform simple analysis, such as comparing the number of ratings and average rating for each movie. Some challenges I expect are handling missing ratings, creating the relationships between the SQL tables, and connecting PostgreSQL with R.