Data Modeling

Purpose

Design robust, maintainable data models for relational and graph data stores with clear schema design principles, normalization strategies, and traversal patterns.

Agent Protocol

Trigger

Exact user phrases: "data model", "schema design", "normalization", "denormalization", "3NF", "table inheritance", "soft delete", "surrogate key", "graph model", "property graph", "RDF", "knowledge graph", "node edge model", "graph traversal".

Input Context

• Data store type (relational, graph, or hybrid)
• Access patterns (OLTP, OLAP, graph queries)
• Volume and growth expectations
• Consistency and integrity requirements
• Existing schema constraints and migration path
• Team expertise with relational vs graph technologies