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 Social Media Profile - 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 Profile Marketing Request - information about the user created request to market a specific profile/post

Primary Key: RequestID

Attributes:

Target_Followers - Integer data, mandatory

Timeline - DateTime data, mandatory

Profile_Id - Foreign Key, mandatory

Date_Created - DateTime data, mandatory

Status - String data, mandatory

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

Primary Key: RequestID

Attributes:

Target_Likes - Integer data, mandatory

Target_Comments - Integer data, mandatory

Timeline - DateTime data, mandatory

Post_ID - Foreign Key, mandatory

Date_Created - DateTime data, mandatory

Status - String data, mandatory

• Entity Service Provider - information about social media marketing service providers

Primary Key: providerID

Attributes:

Name: String data, mandatory

Availability_Status: Boolean data, mandatory

Pricing: Float data, mandatory

Services_Offered: String data, mandatory

Contact_Email: String data, mandatory

1-1 Relations

• Targets - Relation between Profile Marketing Request and Social Media Profile. Every ProfileMarketingRequest targets a single SocialMediaProfile, and every SocialMediaProfile can be targeted by only one ProfileMarketingRequest. Total Participation of ProfileMarketingRequest and partial participation of SocialMediaProfile.

• Targets - Relation between Post Marketing Request and Post. Every PostMarktingRequest targets a single Post, and every Post can be targeted by only one PostMarketingRequest. Total Participation of PostMarketingRequest and partial participation of Post

1-N Relations

• Creates - Relation between User and ProfileMarketingRequest. One User can create many ProfileMarketingRequests, and a specific ProfileMarketing Request is always created by only one User. Total participation of ProfileMarketing Request and partial participation of User.

• Creates - Relation between User and PostMarketingRequest. One User can create many PostMarketingRequests, and a specific PostMarketingRequest is always created by only one User. Total participation of PostMarketingRequest and partial participation of User.

• Has - Relation between SocialMediaProfile and Post. Each SocialMediaProfile can have many Posts, but each Post only belongs to one SocialMediaProfial. Total participation of Post and partial participation of SocialMediaProfile.

• Handled by - Relation between ProfileMarketingRequest and ServiceProvider. Each ProfileMarketingRequest can be handled by one ServiceProvider, while a ServiceProvider can handle many ProfileMarketingRequests. Total participation of ProfileMarketingRequest, partial participation of ServiceProvider.

• Handled by - Relation between PostMarketingRequest and ServiceProvider. Each PostMarketingRequest can be handled by one ServiceProvider, while a ServiceProvider can handle many PostMarketingRequests. Total participation of PostMarketingRequest, partial participation of ServiceProvider.

• Links - Relation between User and SocialMediaProfile. Each User can link many SocialMediaProfiles, while each SocialMediaProfile can be linked to only one user. Total Participation of SocialMediaProfile, partial participation of User