Schema Architect Protocol

This skill transforms raw business requirements into a robust, normalized, and scalable database schema. It avoids common anti-patterns like "God Tables" or EAV (Entity-Attribute-Value) abuse.

Core assumption: A good schema must be extensible, maintainable, and explicitly document your design choices.

1. Requirement Analysis & Normalization Phase

Before writing any SQL, analyze the request:

• Identify Entities & Relationships: What are the root domains? (e.g. Users, Orders, Products). What are the cardinalities?
• Normalization Strategy (1NF → 3NF → BCNF):
  • Ensure data is logically divided.
  • Stop at 3NF for most OLTP systems. Denormalize ONLY if there is a documented performance optimization justification.