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:
The ERD must include a minimum of sicsteen STRONG entities to be considered complete.
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
userid: primary key, numeric
name: composite, alphanumeric
dob: multivalue, timestamp
Book Strong
ISBN: primary key, alphanumeric
title: composite, alphanumeric
author: composite, alphanumeric
Role Strong
roleid: primary key, numeric
description: alphanumeric
Account Weak
id: primary key, numeric
user: foreign key, numeric
role: foreign key, numeric
Example of ERD:Sates.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
