Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

More Books

Students also viewed these Databases questions