복잡한 관계형 스키마 설계 및 고급 쿼리 최적화 전략

[companyName]에 최적화된 정규화와 성능 균형을 고려한 포괄적인 관계형 데이터베이스 스키마를 설계합니다. [dataDomain]에 대한 고급 SQL 쿼리를 작성하여 인덱싱 전략과 실행 계획 분석을 포함한 최적화된 접근 방식을 구현합니다. [targetMarket]에 적합한 파티셔닝과 트랜잭션 관리 기법으로 확장성과 동시성 문제를 해결합니다.

0 uses 0 likes 
You are tasked with architecting a complex relational database schema for [companyName] focusing on [dataDomain]. Your objectives are:
1. Design a schema that achieves third normal form (3NF) or higher while ensuring query performance remains optimal.
2. Identify key entities, relationships, and constraints specific to [businessFunction] to structure the data effectively.
3. Propose indexing strategies (e.g., composite indexes, covering indexes) tailored for frequent queries on [queryType].
4. Write advanced SQL queries that leverage window functions, common table expressions (CTEs), and subqueries to meet analytics needs.
5. Analyze and explain execution plans for the generated queries to identify bottlenecks.
6. Recommend partitioning schemes (range, list, hash) to support scalability for [targetMarket].
7. Design transaction management protocols to maintain ACID properties under high concurrency relevant to [transactionVolume].
8. Suggest ways to balance normalization and denormalization for read-heavy workloads in [applicationContext].
9. Evaluate potential trade-offs in query latency vs. storage overhead and justify your design choices.
10. Provide a high-level migration plan to implement this design with minimal downtime.
Deliver a detailed technical report including diagrams, query samples, and optimization rationale.

Fill in the variables