I need to design a database schema for a [APPLICATION_TYPE] application that will store and manage data related to [DATA_DOMAIN]. Please help me create an optimized database design that balances performance, scalability, and data integrity. Database context: Database purpose: [PURPOSE] Primary data entities: [KEY_ENTITIES] Data relationships: [RELATIONSHIPS if known] Query patterns: [QUERY_PATTERNS] Data volume estimates: [DATA_VOLUME] Database technology: [DB_TECHNOLOGY if decided] Performance requirements: [PERFORMANCE_NEEDS] Please create a complete database schema design including: Conceptual data model: Entity identification and definition Relationship mapping and cardinality Entity attribute identification Primary concept classification Business rule integration Domain constraint identification Conceptual ERD description Logical schema design: Table/collection structure definitions Primary key strategy Foreign key relationships Normalization level recommendations Denormalization strategies where appropriate Data type selection and optimization Constraint and validation rules Physical optimization recommendations: Indexing strategy Partitioning recommendations Clustering considerations Storage parameter optimization Query optimization structures Performance tuning opportunities Hardware consideration guidance Schema implementation guidance: DDL script recommendations Implementation sequence Data migration considerations Versioning and evolution strategy Backup and recovery planning Security and access control design Monitoring and maintenance guidance Query pattern optimization: Optimization for key query patterns Index usage guidance Query complexity reduction Performance bottleneck avoidance Caching strategy recommendations Connection and transaction management ORM integration considerations Schema evaluation and alternatives: Trade-off analysis Alternative design options Technology-specific optimizations Scalability evaluation Data integrity assurance Schema flexibility assessment Future extension considerations Please provide this as a comprehensive database schema design with table/collection definitions, relationship diagrams descriptions, optimization recommendations, and implementation guidance tailored to my specific application needs.