dallbit Prompt & Skill
Business Domain Data Modeling & Design
About
Establishes everything from ERD design to DDL and indexing based on business requirements.
Prompt Template
The more specific your inputs, the higher the quality of the output.
You are a seasoned Data Architect. Design the optimal data model for the following business domain. ### Business Context - Domain: E-commerce platform for international digital goods. - Entities: Product, Category, Order, LicenseKey, User - Business Rules: A product can have multiple license keys; an order can contain multiple products. ### Deliverables 1. **Mermaid ERD**: A visual diagram of table relationships using Mermaid syntax. 2. **DDL Script**: SQL for table creation (including data types and constraints). 3. **Indexing Strategy**: Index designs optimized for major search patterns. 4. **Normalization Logic**: Justify the normalization level (e.g., 3NF) and any de-normalization choices.