Principles of Database Schema Design

As a software developer, I have spent countless hours designing database schemas, together with other professionals. Each time I did such a task, I got better at anticipating possible problems and averting them during the design. My current knowledge is a mixture of my own experience and the ideas of others, most of which I learned from various books and articles.

Today I give back to the community by sharing a curated list of database schema design principles. I believe every database schema designer should be aware of them. I hope they will amplify your experience…