DATA_MODEL

Category: 05. Data & Analytics
Section: Phase 2: Technical Blueprint

5. DATA_MODEL.md

Purpose: To define the data tables, fields, relationships, and data dictionary.

Act as a senior data modeler.
Using the PRD and System Architecture below, design the data model for a data & analytics hackathon project.

PRD: [PASTE PRD]
ARCHITECTURE: [PASTE SYSTEM_ARCHITECTURE]

Provide:
1. Tables/Datasets (Fact tables, Dimension tables, Lookup tables)
2. Columns/Fields
3. Data types (Integer, String, Date, Boolean, Float)
4. Primary keys
5. Foreign keys
6. Relationships (One-to-Many, Many-to-Many)
7. Required fields
8. Optional fields
9. Data dictionary (What each field means)
10. Example records
11. Data quality rules (Nulls, Duplicates, Outliers)

Explain why each table exists.
Keep the data model simple enough for a beginner hackathon team to understand and maintain.