Question: hello I need help making an Enitity relationship Diagram for my video uploading application. Here are the components to use in the diagram: User: UserID

hello I need help making an Enitity relationship Diagram for my video uploading application.
Here are the components to use in the diagram:
User:
UserID (PK)
Username
Email
Password
DateOfBirth
Gender
ProfilePicture
LastLogin
RegistrationDate
Post:
PostID (PK)
UserID (FK)
Content
PostDate
Likes
Comments
Video:
VideoID (PK)
PostID (FK)
Title
Description
UploadDate
Duration
Views
Likes
Dislikes
Format
Resolution
Tags
Categories
Comment:
CommentID (PK)
PostID (FK)
UserID (FK)
Content
CommentDate
Likes
Dislikes
Tag:
TagID (PK)
Name
Category:
CategoryID (PK)
Name
Notification:
NotificationID (PK)
UserID (FK)
Content
Timestamp
Seen (Boolean)
EmailNotification:
EmailNotificationID (PK)
UserID (FK)
Content
Timestamp
Sent (Boolean)
Dashboard:
DashboardID (PK)
UserID (FK)
Content
Report:
ReportID (PK)
ReporterID (FK)
PostID (FK)
Reason
Timestamp
Follower:
FollowerID (PK)
UserID (FK)
FollowerUserID (FK)
FollowDate
SearchHistory:
SearchID (PK)
UserID (FK)
SearchQuery
Timestamp
Feedback:
FeedbackID (PK)
UserID (FK)
Content
Timestamp
Subscription:
SubscriptionID (PK)
SubscriberID (FK)
ChannelID (FK)
SubscriptionDate
TermsAndPrivacy:
TermsAndPrivacyID (PK)
Content
Playlist:
PlaylistID (PK)
UserID (FK)
Title
Description
Posts
Requirements:
1. The ERD must include a minimum of sicsteen STRONG entities to be considered complete.
2. When describing entities, it is imperative to clearly indicate their nature (strong or weak) and include a minimum of three attributes per entity. Attributes should be defined by their domain and form.
Below are examples of entity descriptions:
User (Strong)
user_id: primary key, numeric
name: composite, alphanumeric
dob: multivalue, timestamp
Book (Strong)
ISBN: primary key, alphanumeric
title: composite, alphanumeric
author: composite, alphanumeric
Role (Strong)
role_id: primary key, numeric
description: alphanumeric
Account (Weak)
id: primary key, numeric
user: foreign key, numeric
role: foreign key, numeric
Example of ERD:Sates.
 hello I need help making an Enitity relationship Diagram for my

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!