Following the answer in #3, I was able to get this to run all the way through. The only issue is, as mentioned in #3, the 'Genres' and 'Ratings' tables are not working, and the Actors/Actresses are not actually added to the 'Movies' table. Here are screenshots of all three tables (in DB Browser for SQLite). I'm aware that the creator of this abandoned this project a long time ago, but I'm wondering if there is anybody out there who knows how to fix this? I'm a beginner to SQL and Ruby, but maybe it has something to do with the syntax of the 'INSERT INTO's in the Ruby script? Any help is greatly appreciated. Thank you very much.
Following the answer in #3, I was able to get this to run all the way through. The only issue is, as mentioned in #3, the 'Genres' and 'Ratings' tables are not working, and the Actors/Actresses are not actually added to the 'Movies' table. Here are screenshots of all three tables (in DB Browser for SQLite). I'm aware that the creator of this abandoned this project a long time ago, but I'm wondering if there is anybody out there who knows how to fix this? I'm a beginner to SQL and Ruby, but maybe it has something to do with the syntax of the 'INSERT INTO's in the Ruby script? Any help is greatly appreciated. Thank you very much.