Diagram

ERD

Data Requirements

Entities

• Entity User- information about users

Primary Key: UserID.

Attributes:

Username - String data, mandatory.

Email - String data, mandatory.

Password - String data, mandatory.

Contact_Details - String data, mandatory.

• Entity SocialMediaProfile - information about the users linked social media profiles.

Primary Key: ProfileID

Attributes:

Platform - String data, mandatory

User_Name - String data, mandatory

Account_Type - String data, mandatory (ex. public, private..)

Followers_Count - Integer data, mandatory

• Entity Post - information about the post from a certain social media profile.

Primary Key: PostID

Attributes:

Content - String data, optional

Post_Date - DateTime data, optional

URL - String data, mandatory

Likes_Count - Integer data, mandatory

Comments_Count - Integer data, mandatory

• Entity Marketing Request - information about the user created request to market a specific profile/post

Primary Key: RequestID

Attributes:

Target_Followers - Integer data, optional Target_Likes - Integer data, optional Target_Comments - Integer data, optional