Movie Ratings

Introduction

Data:

1) I would be surveying my family for six recent popular movies (Wicked, Michael, The Housemaid, The Odyssey, Toy Story 5, Spider-Man -Brand New Day)

2) I will allow the ratings to be on a scale of 1 to 5.

3) I would be using SQLite for my database

4) I would make sure that I account for missing data by assigning it a NULL and verifying that value it rather than considering that a rating of 0.

Data Storage & Retrieval:
1) Database of 3 tables with two columns each min, will use SQL to create it.
2) I will export SQL data to a .csv file and load it into R as a dataframe
3) This should allow me to practice using primary keys, foreign keys, and joins to connect the

Challenge: I expect that it will be a bit of a challenge to sure that the relationships between the SQL tables are set up correctly and that the data can be imported into R without errors.