...
Please comment on other attributes that could be included or taken out, or any description edits, or anything else that should be taken out!
Data dictionary in Word doc Excel format
(This is difficult to look at but if you would like, please leave comments!)
(Please put comments on this Wiki page, while viewing this document!)
Visual model of databaseVisual model of database (with attributes)
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