We want to develop an online platform called “MovieBox” that has movies, documentaries, dramas, cartoons of different regions around the world. The user can subscribe to our website “MovieBox” to watch the videos of their choice. Our website would be an online platform like Netflix and HBO. We want to you to design and develop a database system that keep track of all the videos, subscribers and the video watched by each subscriber. Your system should allow user to rate videos and watch a list of videos they have watched or desire to view. Work on the details that the platform needs to maintain for smooth operations and answer the following questions: a) What do you think are the main objects (entities) that need to be represented in the database? b) What relationships do you think exist between these main objects (entities)? c) For each of the objects, what details do you think need to be held in the database (attributes)? Also identify keys and foreign keys. d) What queries do you think are required? List at least 10 queries. An example of a query would be: List the most popular movies of 2020. e) Would you use 2-tier architecture or 3-tier architecture for DBMS? Justify.
Need solution for part c
We want to develop an online platform called “MovieBox” that has movies, documentaries, dramas, cartoons of
different regions around the world. The user can subscribe to our website “MovieBox” to watch the videos of their
choice. Our website would be an online platform like Netflix and HBO.
We want to you to design and develop a
watched by each subscriber. Your system should allow user to rate videos and watch a list of videos they have
watched or desire to view.
Work on the details that the platform needs to maintain for smooth operations and answer the following questions:
a) What do you think are the main objects (entities) that need to be represented in the database?
b) What relationships do you think exist between these main objects (entities)?
c) For each of the objects, what details do you think need to be held in the database (attributes)? Also
identify keys and foreign keys.
d) What queries do you think are required? List at least 10 queries.
An example of a query would be: List the most popular movies of 2020.
e) Would you use 2-tier architecture or 3-tier architecture for DBMS? Justify.
Step by step
Solved in 2 steps
