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)
• Inheritance is indicated by the inherited primary key wrapped with "*" only in the first occurrence of the table, then in subsequent occurrences the primary key of the base class is referenced.

Tables

users

(UserID, Username, Email, Password, Contact_Details)

social_media_profile

(*ProfileID#(users)*, Platform, User_Name, Account_Type, Followers_Count)

post

(*PostID#(social_media_profile)*, Content, Post_Date, URL, Likes_Count, Comments_Count)

profile_marketing_request

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

post_marketing_request

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

service_provider

(ProviderID, Name, Availability_Status, Pricing, Services_Offered, Contact_Email)