Installing required packages

## Installing package into 'C:/Users/humberh/Documents/R/win-library/3.5'
## (as 'lib' is unspecified)
## Warning: unable to access index for repository http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/3.5:
##   cannot open URL 'http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/3.5/PACKAGES'
## package 'RMySQL' successfully unpacked and MD5 sums checked
## 
## The downloaded binary packages are in
##  C:\Users\humberh\AppData\Local\Temp\RtmpigS2jo\downloaded_packages
## Loading required package: DBI

Defining MySQL Instance connection and testing Database connectivity

movrevdb <- dbConnect(RMySQL::MySQL(), user='root', password='Pass@word1', dbname='moviereviews', host='localhost')
dbListTables(movrevdb)
## [1] "movies"    "reviewers"

Loading data into a dataframe and displaying data in R

query <- dbSendQuery(movrevdb, "select M.movieId, M.title, R.revId, R.revname, R.rating
                     from movies M
                     inner join reviewers R
                     on M.movieId = R.movieId")

movrev_df <- fetch(query)
movrev_df
##    movieId                  title revId  revname rating
## 1       10          Black Panther     1      Mom      3
## 2       20      A Wrinkle in Time     2      Mom      5
## 3       30              Tom Rider     3      Mom      2
## 4       40           Isle of Dogs     4      Mom      1
## 5       50 Avengers: Infinity War     5      Mom      4
## 6       60          Incredibles 2     6      Mom      5
## 7       10          Black Panther    11 Daughter      2
## 8       20      A Wrinkle in Time    22 Daughter      5
## 9       30              Tom Rider    33 Daughter      1
## 10      40           Isle of Dogs    44 Daughter      5
## 11      50 Avengers: Infinity War    55 Daughter      2
## 12      60          Incredibles 2    66 Daughter      5
## 13      10          Black Panther   111  Friend1      5
## 14      20      A Wrinkle in Time   222  Friend1      1
## 15      30              Tom Rider   333  Friend1      5
## 16      40           Isle of Dogs   444  Friend1      3
## 17      50 Avengers: Infinity War   555  Friend1      5
## 18      60          Incredibles 2   666  Friend1      3
## 19      10          Black Panther  1111  Friend2      1
## 20      20      A Wrinkle in Time  2222  Friend2      4
## 21      30              Tom Rider  3333  Friend2      2
## 22      40           Isle of Dogs  4444  Friend2      5
## 23      50 Avengers: Infinity War  5555  Friend2      2
## 24      60          Incredibles 2  6666  Friend2      4
## 25      10          Black Panther 11111     Wife      1
## 26      20      A Wrinkle in Time 22222     Wife      5
## 27      30              Tom Rider 33333     Wife      1
## 28      40           Isle of Dogs 44444     Wife      3
## 29      50 Avengers: Infinity War 55555     Wife      1
## 30      60          Incredibles 2 66666     Wife      5