Question: 1 . EntitiesUserAttributes: UserID, Username, AccountStatus, Role ( User / Admin ) Relationships:Can have multiple Accounts ( max 3 ) . Can add or delete
EntitiesUserAttributes: UserID, Username, AccountStatus, Role UserAdminRelationships:Can have multiple Accounts max Can add or delete words in their PersonalDB if UserCan manage Users and GeneralDB if AdminAccountAttributes: AccountID, Platform, AccountStatusRelationships:Associated with one User.Imports Posts for monitoring.PostAttributes: PostID, Content, Timestamp, Status CheckedUnchecked IsOffensiveRelationships:Belongs to one Account.Gets processed for offensive content based on GeneralDB and PersonalDB.PersonalDB Userspecific database of offensive wordsAttributes: PersonalDBID, Word, UserIDRelationships:Owned by a User.GeneralDB Global database of offensive wordsAttributes: WordID, Word, CategoryRelationships:Maintained by an Admin.AdminAttributes: AdminID, AdminPrivilegesRelationships:Controls Users and GeneralDB.RelationshipsUserUserID Primary KeyUsernameAccountStatusRole UserAdminAccountAccountID Primary KeyPlatformAccountStatusUserID Foreign KeyPostPostID Primary KeyContentTimestampStatus CheckedUncheckedIsOffensive BooleanAccountID Foreign KeyPersonalDBPersonalDBID Primary KeyWordUserID Foreign KeyGeneralDBWordID Primary KeyWordCategoryAdminAdminID Primary KeyAdminPrivileges Draw this Er model
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
