Question: 1 . EntitiesUserAttributes: UserID, Username, AccountStatus, Role ( User / Admin ) Relationships:Can have multiple Accounts ( max 3 ) . Can add or delete

1. EntitiesUserAttributes: UserID, Username, AccountStatus, Role (User/Admin)Relationships:Can have multiple Accounts (max 3).Can add or delete words in their PersonalDB (if User).Can manage Users and GeneralDB (if Admin).AccountAttributes: AccountID, Platform, AccountStatusRelationships:Associated with one User.Imports Posts for monitoring.PostAttributes: PostID, Content, Timestamp, Status (Checked/Unchecked), IsOffensiveRelationships:Belongs to one Account.Gets processed for offensive content based on GeneralDB and PersonalDB.PersonalDB (User-specific database of offensive words)Attributes: PersonalDBID, Word, UserIDRelationships:Owned by a User.GeneralDB (Global database of offensive words)Attributes: WordID, Word, CategoryRelationships:Maintained by an Admin.AdminAttributes: AdminID, AdminPrivilegesRelationships:Controls Users and GeneralDB.RelationshipsUserUserID (Primary Key)UsernameAccountStatusRole (User/Admin)AccountAccountID (Primary Key)PlatformAccountStatusUserID (Foreign Key)PostPostID (Primary Key)ContentTimestampStatus (Checked/Unchecked)IsOffensive (Boolean)AccountID (Foreign Key)PersonalDBPersonalDBID (Primary Key)WordUserID (Foreign Key)GeneralDBWordID (Primary Key)WordCategoryAdminAdminID (Primary Key)AdminPrivileges. Draw this Er model

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 Programming Questions!