Project 004: Social Platform Database

MySQL • ER Modeling • Schema Design • Coursework (Individual)

Overview

Designed a relational database for a “news-focused social platform” (NEWSPAPER.NET). The model supports hubs, posts, external/internal post links, users, user connections, comments, moderators, moderation reports, and AI agents.

The assignment required a conceptual ER model (hand-drawn) and a physical ER model (MySQL Workbench).

My Role

Individual project — designed the conceptual and physical models end-to-end
Translated business rules into entities, relationships, and constraints
Produced a MySQL-ready schema (SQL) for implementation

Design Artifacts

This PDF contains my hand-drawn conceptual ER diagram (Chen notation) and the MySQL Workbench physical ER model export.

Download ER Models (PDF) Download Assignment Spec (PDF) Go to Code Page

Tip: zoom out or download for clearer text and detail.

Specification Summary (What the database must support)

The spec describes NEWSPAPER.NET, including hubs with posts, external URLs and post-to-post links, user accounts and bi-directional connections, comments with tagging, moderator assignments with reports, and optional AI agent tracking.