상황
Design an ERD to support ETL processes for ingesting social media data (posts, users, engagements) and storing processed analytics.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
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.