Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Design a conceptual database design for a video streaming platform similar to YouTube. In the platform, you have multiple actors for example content creators, viewers,
Design a conceptual database design for a video streaming platform similar to YouTube. In the platform, you have multiple actors for example content creators, viewers, AD agencies, and the admin of the platform. The platform generates its revenue from the Ads placed inside the videos, these ads are of different categories i.e., video ads, image ads, short pause ads, etc., and each of these ads has different pricing per video per view, moreover, the price of ads is different for every location. To place an Ad, ad agencies can create an account on the platform and subscribe to the Ads on the videos. There are other actors on the platform such as content creators, who can create a free account on the platform and post their videos. Content creators can also view the content of other content creators, they can subscribe to their channel, and react to individual videos by liking or disliking, or even by comments. Content creators can enable ads on their videos, and they are paid based on the number of views on the particular video. You need to create an ERD diagram for the above scenario. You should clearly mention all the entities and their attributes, and their relation with entities. You should also clearly mention the cardinality between the relations as well. For this question, you need to be as creative as you can, and you should try to handle as many scenarios as you can, do imagine how a real-world video streaming platform would work
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started