The core schema-design principles I follow
Here are the core schema-design principles I follow: Start from the business grain: define exactly what one row represents, e.g. “one trade execution” or “daily account balance per portfolio and currency.” Everything follows from this. Preserve raw data: keep an…