databasenormalizationdiagramdatabase-normalizationdatabase-diagram

Recommend Software for Drawing a Normalization Diagram


I want to draw database diagram. I should draw normalization steps.

I want to draw diagram like this and show functional dependency!

                           --------------------------
                           |            |           |
                           |            v           v
                     -------------------------------------
                     | user_name  | first_name | last_name|
                     --------------------------------------

Do you know any open source software to draw a diagram like this?

I use from DIA but Dia not support diagram like this


Solution

  • ORM is an excellent diagrammatic way to represent dependencies. I don't think there is any standard notation for exactly the type of diagram you are looking for but ORM will do the job nicely. You can even generate a normalized database design directly from an ORM model.