Design an ER diagram for a video-sharing platform similar to YouTube.
Discuss any assumptions you make. The platform needs to keep track of the
following information:
Users: Each user is identified by a unique user ID and has associated attributes such
as username, email address, and date of registration.
Videos: Each video is identified by a unique video ID and has attributes such as title
and duration. Users have the capability to upload multiple videos, but a video can
only be uploaded by a single user.
Comments: Each comment is identified by a unique comment ID and includes
attributes such as content and date. Users can leave multiple comments on videos,
and each video can have multiple comments associated with it.
Likes: Users have the ability to like videos. A user can like multiple videos, and each
video can receive likes from multiple users.
Followers/Following: Users can follow each other, allowing for a user to have
multiple followers. Additionally, a user can follow multiple other users.
In the system, when a user is deleted, their comments will be deleted as well.
However, their videos will remain intact.
It is possible for users to create an account without uploading any videos, and without
liking or commenting on any content.
Additionally, users can have zero followers and following connections.
Your task is to create an ER diagram that accurately represents the relationships,
attributes, and participation and cardinality ratios described above.