So my largest struggle when starting a new app is creating my models. I always try to keep my models in 3 NF. I use navicat data designer to try and design my entities on paper. But I always have the argument with myself “is this the best place to put this entity”. I believe I overthink and try and be a DBA when my strength is “making things work”.
Our infrastructure uses mssql server and entity framework (for reference).
What tips / tricks , books, software do y’all recommend?