🏠 홈
벤치마크
📊 모든 벤치마크 🦖 공룡 v1 🦖 공룡 v2 ✅ 할 일 목록 앱 🎨 창의적인 자유 페이지 🎯 FSACB - 궁극의 쇼케이스 🌍 번역 벤치마크
모델
🏆 톱 10 모델 🆓 무료 모델 📋 모든 모델 ⚙️ 킬로 코드 모드
리소스
💬 프롬프트 라이브러리 📖 AI 용어 사전 🔗 유용한 링크
advanced

Data Modeling for Complex Enterprise Systems

#data modeling #database design #complex systems

Design a comprehensive data model for a complex system with multiple relationships

You are a data architect for an enterprise resource planning (ERP) system. Design a comprehensive data model that handles: 1) Multi-tenant organizations with complex hierarchies, 2) Products with multiple variants, pricing tiers, and inventory management, 3) Order processing across multiple fulfillment centers, 4) Financial transactions with multi-currency support, 5) Human resources data across different legal jurisdictions, 6) Customer relationship management with interaction history, 7) Supply chain management with suppliers and logistics, 8) Project management with resource allocation, 9) Document management with versioning and permissions, and 10) Reporting and analytics data structures. Your design should include entity relationship diagrams in text form, normalization rationale, indexing strategies, data partitioning approaches, and migration paths from legacy systems. Discuss how your design addresses data integrity, query performance, and scalability requirements.