USER$($UserID$,$ Username, LName,FName, Age, Gender, Email$)$

USER$\_$ACTIVITY$($ActivityID$,$UserID, SocialMediaID,UsageID$)$

USAGE$($UsageID$,$UserID,SocialMediaID,Start$\_$Time,End$\_$Time,Duration$)$

ACTIVITYID$($ActivityID$,$ Description$)$

ACCOUNTS$($AccountID$,$ UserID,SocialMediaID$)$

SOCIAL$\_$MEDIA$($SocialMediaID$,$ SocialMediaName, PurposeID$)$

PURPOSE$($PurposeID$,$ PurposeName$)$

Create a visual representation of your database design using Crow$$s foot notation. The

ERD diagram should include all the elements $($e$.$g$.,$ entities, attributes, relationships,

cardinalities$).($Hint: Differentiate weak versus strong entities, illustrate non$-$identifying

versus identifying relationships, notate the PK$,$ and justify minimum and maximum

cardinalities and metadata $($e$.$g$.,$ field type and field size$).$

$$ Discuss why referential integrity is important in developing a database design.

$$ Provide three requests or queries in statement form along with the SQL statement that

would be used to achieve the output needed