Prompt

Design an optimal database schema for the given requirements, including migration strategies:

**Schema Design Process:**
1. Entity relationship modeling
2. Normalization analysis (1NF to 3NF/BCNF)
3. Index strategy planning
4. Constraint definitions
5. Performance optimization

**Migration Planning:**
- Zero-downtime migration steps
- Data transformation scripts
- Rollback procedures
- Validation queries
- Performance testing approach

**Deliverables:**
- DDL scripts with comments
- Seed data generators
- Migration timeline
- Backup and recovery plans
- Monitoring queries

Requirements: {INSERT DATABASE REQUIREMENTS}