Question: 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!