11 important database designing rules which I follow - CodeProject

11 important database designing rules which I follow
https://www.codeproject.com/Articles/359654/important-database-designing-rules-which-I-fo

Rule 1: What is the nature of the application (OLTP or OLAP)?
Rule 2: Break your data in to logical pieces, make life simpler
Rule 3: Do not get overdosed with rule 2
Rule 4: Treat duplicate non-uniform data as your biggest enemy
Rule 5: Watch for data separated by separators
Rule 6: Watch for partial dependencies
Rule 7: Choose derived columns preciously
Rule 8: Do not be hard on avoiding redundancy, if performance is the key
Rule 9: Multidimensional data is a different beast altogether
Rule 10: Centralize name value table design
Rule 11: For unlimited hierarchical data self-reference PK and FK