database-schema-design

Design and optimize SQL and NoSQL database schemas with normalization, indexing, and migration strategies. Lists specific situations where this skill should be triggered: The required and optional input information to collect from the user: Specifies the step-by-step task sequence to follow precisely. Identify core data objects and their attributes. Tasks : Example (E-commerce): Define relationships between tables and apply normalization. Tasks : Decision Criteria : Example (ERD Mermaid): Design indexes for query performance. Tasks : Checklist : Example (PostgreSQL): Add constraints to ensure data integrity. Tasks : Example : Write migrations that safely apply schema changes. Tasks : Example (SQL migration): Defines the exact format that deliverables should follow.