🏠 Trang chủ
Benchmark
📊 Tất cả benchmark 🦖 Khủng long v1 🦖 Khủng long v2 ✅ Ứng dụng To-Do List 🎨 Trang tự do sáng tạo 🎯 FSACB - Trình diễn cuối cùng 🌍 Benchmark dịch thuật
Mô hình
🏆 Top 10 mô hình 🆓 Mô hình miễn phí 📋 Tất cả mô hình ⚙️ Kilo Code
Tài nguyên
💬 Thư viện prompt 📖 Thuật ngữ AI 🔗 Liên kết hữu ích
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.