확장 가능한 데이터 생태계를 위한 복합 관계형 스키마 설계 및 쿼리 최적화 전략

You are tasked with designing an advanced relational database system for [companyName], operating within the [targetMarket]. Your objectives include:
1. Propose a normalized schema design up to at least the third normal form (3NF), explicitly detailing table structures and relationships.
2. Identify and justify indexing strategies for optimizing complex join queries involving [keyTables] and [keyAttributes].
3. Develop advanced SQL queries that efficiently handle multidimensional filtering, aggregation, and sorting on [transactionData] and [userBehavior] datasets.
4. Recommend query optimization techniques such as execution plan analysis, partitioning, and materialized views tailored to [productName] data flows.
5. Analyze and document potential bottlenecks in large-scale query processing scenarios, proposing mitigation strategies.
6. Consider trade-offs between read-heavy and write-heavy workload optimizations relevant to [operationalHours] and peak usage periods.
7. Incorporate data integrity constraints and ensure referential integrity across [criticalTables].
8. Suggest backup and recovery procedures to safeguard [businessCriticalData] without sacrificing system availability.
9. Provide a roadmap for scaling the database schema and query performance to accommodate projected growth over [timeframe].
Craft your response with technical depth and clarity, supporting your recommendations with examples and rationale.