search

kwongjose / CS364_Project

This is the Repo for our CS364 Database project.
0 stars 0 forks source link

DB connection #4

Closed kwongjose closed 7 years ago

kwongjose commented 8 years ago

Make the connection string / connection to the DB (will need to know what the DB is called first coordinate with whoever is making the DB

kwongjose commented 7 years ago

Just a few notes if you want them. I would list all the genres in one column like (comedy, action, ect) we can use the LIKE keyword to find them. Also looks like there are no second directors so i would take that out as well. I would replace metacriticlink with the IMDB rating as we will need that to match up with our ER diagram. Also maybe add a second streaming service for a few of the movies in StreamsOn but honestly that is not as important as the rest. The easiest way to make theses changes would be to use use DB browser and use the GUI. No point in putting in the work in the code since we don't have a way to add movies to the database from the GUI anyway.

Other than that it looks good! I appreciate the work.