O cenário
Design an ERD to support ETL processes for ingesting social media data (posts, users, engagements) and storing processed analytics.
O que há neste desenho
Entenda as decisões por trás dele.
01
Used separate tables for raw and processed posts to track ETL transformations
02
Modeled user as a dimension with snapshot attributes
03
Aggregated daily metrics for efficient reporting
04
Explicit one-to-one relationship from processed to raw post to ensure lineage
Suitable for any social media analytics pipeline needing a staging and analytics database schema.