Data Modelling Skill

Database schema design for OLTP uses normalized 3NF structures for transactions, while OLAP dimensional modeling applies star or snowflake schemas for analytical queries. This Skill maps your requirements to the appropriate schema type and generates vendor-specific SQL DDL.

Universal data model patterns are proven structural templates like Party, Product, Order, and Accounting that map real business entities to relational tables. This Skill uses them to design clean schemas reflecting business logic without unnecessary complexity.

You generate SQL DDL by defining your business domain and key entities. This Skill outputs concrete table, column, and relationship designs, translating them directly into CREATE TABLE statements tailored to your specific SQL dialect.

Add temporal or versioning complexity to a database schema only when business rules explicitly require tracking historical changes. This Skill recommends the simplest viable schema variant first, adding complexity solely when necessary to preserve data integrity.

Model pricing and ordering concepts using universal data model patterns that cleanly represent entity roles and transaction structures. This Skill designs these mapped schemas while explaining trade-offs between normalization and query performance.