One idea could be to have buttons in the top-left corner of the table which would act sort of like tabs. By clicking the "Marvel" tab, the marvel information table is fetched, and by clicking the Jul tab, the regular table should be displayed. However, main functionality is just to display the marvel movies.
In the database there exists the "marvel" table which contains the ID, name, imdb_rating, our rating (aka average rating). The marvel_participated table, containing the movieID as a foreign key, the participant ID as a foreign key and the grade that individual user give the movie. Lastly there's the marvel_movies view which contains the movieID and the calculated average score.
One idea could be to simply add a column for each individual participant to the marvel_participated table and use that to display information in the table cell.
One idea could be to have buttons in the top-left corner of the table which would act sort of like tabs. By clicking the "Marvel" tab, the marvel information table is fetched, and by clicking the Jul tab, the regular table should be displayed. However, main functionality is just to display the marvel movies.
In the database there exists the "marvel" table which contains the ID, name, imdb_rating, our rating (aka average rating). The marvel_participated table, containing the movieID as a foreign key, the participant ID as a foreign key and the grade that individual user give the movie. Lastly there's the marvel_movies view which contains the movieID and the calculated average score.
One idea could be to simply add a column for each individual participant to the marvel_participated table and use that to display information in the table cell.