Streamathon is a relatively new movie-streaming platform, where its 2,000 daily-active users have access to over 300 different movie titles on-demand. Our team intends to build a database designed to keep track of user-based movie ratings and subscriptions to gauge which movie contracts have been most profitable. Additional key metrics will include customer profile details and movie genre preferences, to provide insights that inform strategic decisions at the company’s business intelligence unit. Ultimately, these insights will play a pivotal role in determining how Streamathon curates and maintains its content catalog.
Our Database Management System is hosted on http://flip2.engr.oregonstate.edu:7267/users and features eight total pages: one index page and seven pages for our entities: Movies, Users, Subscriptions, SubscriptionTiers, Genres, Ratings, and MoviesGenresTable. The Movies, Users, and Ratings pages have full CRUD – CREATE, READ, UPDATE, and DELETE functionality. Subscriptions, SubscriptionTiers, Genres, and MoviesGenresTable each have CRU – CREATE, READ, AND UPDATE functionality.
Handlebars files: (movies.hbs, users,hbs, subscriptions.hbs, subtiers.hbs, genres.hbs, ratings.hbs, movgentable.hbs)
Code Adapted from: CS340 Canvas Module Week 6: Exploration - Web Application Technology by Professor Curry: https://canvas.oregonstate.edu/courses/1946034/pages/exploration-web-application-technology?module_item_id=23809327
Steps 3 and 7: CS 340 GitHub: Node-Starter-JS Tutorial Guide by Professor Curry: https://github.com/osu-cs340-ecampus/nodejs-starter-app/tree/main/Step%203%20-%20Integrating%20a%20Templating%20Engine%20(Handlebars)
Code Adapted from: OSU CS 340 Github Node-Starter-JS Tutorial Guide Steps 0, 3 and 5 by Professor Curry:
https://github.com/osu-cs340-ecampus/nodejs-starter-app/tree/main/Step%205%20-%20Adding%20New%20Data
OSU CS 340 Canvas: Activity 5 - SQL Queries of Multiple Tables (JOINS) by Professor Curry:
OSU CS 340 Canvas Activity 1 - Creating a Customer Object Table on Canvas by Professor Curry:
OSU CS 340 Canvas: Exploration on Database Application Design on Canvas by Professor Curry:
OSU CS 340 Canvas Exploration - MySQL Cascade on Canvas by Professor Curry:
Code adapted from: OSU 340 Github: Node-Starter-JS Tutorial Guide - Step 5: Adding New Data by Professor Curry
Code adapted from: OSU 340 Github: Node-Starter-JS Tutorial Guide - Step 7: Dynamically Deleting Data by Professor Curry:
Code adapted from: OSU 340 Github: Node-Starter-JS Tutorial Guide - Step 8: Dynamically Updating Data by Professor Curry: