https://www.talend.com/blog/2017/05/05/data-model-design-best-practices-part-1/
https://www.talend.com/blog/2017/07/31/data-model-design-best-practices-part-2/
DATA MODEL ASPECT | HOLISTIC | CONCEPTUAL | LOGICAL | PHYSICAL |
Data Silos | √ | |||
Data Silo Relationships | √ | |||
Element Names | √ | |||
Element Relationships | √ | |||
Element Generalizations | √ | |||
Element Items | √ | |||
Entity Names | √ | |||
Entity Relationships | √ | |||
Entity Keys | √ | |||
Entity Attributes | √ | |||
Entity Constraints | √ | |||
Table / View Names | √ | |||
Column Names | √ | |||
Column Data Types | √ | |||
Column Default Values | √ | |||
Primary / Foreign Keys | √ | |||
Index Names | √ | |||
Index Properties | √ | |||
Storage Configurations | √ |