| | 1 | = Relational Design = |
| | 2 | |
| | 3 | == Signs == |
| | 4 | - Primary keys are indicated by bold and underlined letters |
| | 5 | - Mandatory attributes are marked in bold |
| | 6 | - Foreign keys are indicated by a # followed by the name of the referenced table, wrapped in (). - attb#(table) |
| | 7 | - 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. |
| | 8 | |
| | 9 | = Tables = |
| | 10 | |
| | 11 | == users == |
| | 12 | (**__UserID__**, **Username**, **Email**, **Password**, **Contact_Details**) |
| | 13 | |
| | 14 | == social_media_profile == |
| | 15 | (*ProfileID#(users)*, **Platform**, **User_Name**, **Account_Type**, **Followers_Count**) |
| | 16 | |
| | 17 | == post == |
| | 18 | (*PostID#(social_media_profile)*, Content, Post_Date, **URL**, **Likes_Count**, **Comments_Count**) |
| | 19 | |
| | 20 | == profile_marketing_request == |
| | 21 | (RequestID, **Target_Followers**, **Timeline**, *ProfileID#(social_media_profile)*, **Date_Created**, **Status**, ProviderID#(service_provider)) |
| | 22 | |
| | 23 | == post_marketing_request == |
| | 24 | (RequestID, **Target_Likes**, **Target_Comments**, **Timeline**, *PostID#(post)*, **Date_Created**, **Status**, ProviderID#(service_provider)) |
| | 25 | |
| | 26 | == service_provider == |
| | 27 | (ProviderID, **Name**, **Availability_Status**, **Pricing**, **Services_Offered**, **Contact_Email**) |
