Data Model Review

Review the data model design for {{feature_or_system}}.

Proposed model: {{model}}
Use cases: {{use_cases}}
Scale requirements: {{scale}}

**Review Framework:**

**1. Completeness**
- Are all required entities present?
- Are all relationships captured?
- Are all use cases supported?

**2. Normalization**
- Is data appropriately normalized?
- Where is denormalization justified?
- Data duplication implications?

**3. Relationships**
- Are cardinalities correct?
- Are foreign keys appropriate?
- Cascade/orphan handling?

**4. Data Types**
- Are types appropriate?
- Precision considerations?
- Null handling?

**5. Extensibility**
- How does this evolve?
- Future requirements accommodated?
- Breaking change risks?

**6. Performance**
- Query patterns supported?
- Index recommendations?
- Partition considerations?

**7. Integrity**
- Constraints defined?
- Validation rules?
- Referential integrity?

**8. Security**
- Sensitive data identified?
- Access control model?
- Audit requirements?

**Review Summary:**

| Area | Status | Issues | Recommendations |

**Critical Issues:**
- Must-fix before implementation

**Recommendations:**
- Should-consider improvements