governing-entity-boundaries

What problem does it solve?

This Skill provides a decision framework for designing database schemas by governing entity boundaries, normalization levels, and junction table design, preventing issues like "god tables" or join explosions.

Core Features & Use Cases

• Normalization Diagnostics: Guides through 1NF, 2NF, and 3NF checks to ensure data integrity and reduce redundancy.
• Denormalization Guidance: Provides criteria for when and how to denormalize for performance gains, with clear decision rules.
• Table Width Heuristics: Offers signals and thresholds for decomposing overly wide tables or consolidating fragmented ones.
• Junction Table Design: Details best practices for many-to-many relationships, including PK strategies and indexing.
• Entity Boundary Heuristics: Helps decide when to split or merge tables based on data concepts and lifecycles.
• Use Case: When designing a new e-commerce schema, use this Skill to determine the optimal way to structure tables for products, customers, orders, and their relationships, ensuring scalability and maintainability.

Quick Start

Use the governing-entity-boundaries skill to evaluate the normalization of the 'orders' table.