...
Basic Entity-Relationship Diagram of database (only table names and fact table attributes)
Notes on ER Diagram:
- Across the top – information that will likely come from every source (we will always have person and source from every activity)
- The rest of the tables are the possible activities in which a person (fan) can partake
- The activity_fact table connects the person, the person's location while doing the activity, our source, and the activity itself