Database Denormalization Advisor

Advise on denormalization for this normalized schema:

**Current Schema:**
```sql
{{CURRENT_SCHEMA}}
```

**Performance Issues:**
{{PERFORMANCE_ISSUES}}

**Query Patterns:**
{{QUERY_PATTERNS}}

**Read/Write Ratio:** {{READ_WRITE_RATIO}}
**Database System:** {{DATABASE_SYSTEM}}

Please provide:
1. Analysis of current normalization level
2. Denormalization recommendations:
   - Pre-computed columns
   - Summary tables
   - Duplicate columns for avoiding JOINs
3. Trade-off analysis for each recommendation
4. Data synchronization strategies
5. Trigger-based vs. application-based updates
6. Modified schema with denormalization
7. Query simplifications
8. Performance improvement estimates
9. Data consistency safeguards