Search code examples
mysqlrelational-databaseentity-relationshipdiagramdatabase-normalization

Do I create an ER Diagram before or after normalization?


I'm learning about creating databases in MySQL and one of the theoretical parts is developing ER diagram. Do I really need it when making my own project? And if I want to create one, do I create it after normalization of relations?


Solution

  • 1). You're not required to do it. But it can definitely help to keep a clear overview over your scheme.

    2). I'd just start by making an ER diagram and updating it after, or during, normalization. You could use tools like MySql Workbench to easily make and manage ER diagrams