התרחיש
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.