Add revenue to movie data

nicford / Movilytics

Welcome to our website Movylitics, a Sophisticated GroupLens dataset and tmdb analytics exploration tool.

BSD 3-Clause "New" or "Revised" License

3 stars 3 forks source link

Add revenue to movie data #16

Closed nicford closed 3 years ago

nicford commented 3 years ago

also, movie release date

SteveLim99 commented 3 years ago

Please also include upcoming movies and redesign some parts of the db schema to incorporate the new elements if required. Also note that the translation data has been loaded on to the database under the name "translations"

SteveLim99 commented 3 years ago

@kimdanny we should also start planning for the fact table to store some pre-calculated variables, things like average rating and standard deviation can be included in the fact table for the time being. I have completed the query for use case 3 and the query takes about 120ms to run via pgadmin so it may be somewhat beneficial to store these values.

kimdanny commented 3 years ago

Added year column in movies table
Added revenue in movies
Added upcoming movies in movies table with its status 'upcoming'
Created Translations table with field 'mid' and 'language_id', which can be connected to language_id in Language_info DB table

Closing this issue