Choosing the Appropriate Data-type – Problem Prevention
Diagram illustrating an approach to Choosing the Appropriate Data-type for SQL columns. The intention is problem prevention in the Logical Data Model. The approach diagram emphasises separating “presentation” from “storage” and suggests that storage type should be decided in three steps: What you need, How you will store it, and the precise SQL data-type. The objective is to avoid SQL smells.