= Relational Design =

== Signs == 
- Primary keys are indicated by bold and underlined letters
- Mandatory attributes are marked in bold
- Foreign keys are indicated by a # followed by the name of the referenced table, wrapped in (). - attb#(table)

= Tables =

user (**__UserID__**, **Username**, **Email**, **Password**, **Contact_Details**)

social_media_profile (**__ProfileID__**, **Platform**, **User_Name**, **Account_Type**, **Followers_Count**, **UserID#(user)**)

post (**__PostID__**, Content, Post_Date, **URL**, **Likes_Count**, **Comments_Count**, **ProfileID#(social_media_profile)**)

profile_marketing_request (**__RequestID__**, **Target_Followers**, **Timeline**, **Date_Created**, **Status**, **ProfileID#(social_media_profile)**, **ProviderID#(service_provider)**)

post_marketing_request (**__RequestID__**, **Target_Likes**, **Target_Comments**, **Timeline**, **Date_Created**, **Status**, **PostID#(post)**, **ProviderID#(service_provider)**)

service_provider (**__ProviderID__**, **Name**, **Availability_Status**, **Pricing**, **Services_Offered**, **Contact_Email**)

= DDL Script =

[attachment:ddlScript.sql SQL script] for deleting and creating tables.