A diagram is a graphical representation of information that depicts the structure, relationship, or operation of anything. Diagrams enable your audience to visually grasp hidden information and engage with them in ways that words alone cannot. Depending on the type of project, there are numerous ways to use diagrams. For example, if you want to depict the relationship between distinct pieces, we usually use an Entity Relationship Diagram (ERD). There are many great tools that can help you sketch out your database designs beautifully.
In this article, I will be sharing some of my favorite tools that I use to curate my data structures and bring my ideas to life.
Google Docs Drawing
The drawing function in Google Docs allows you to add illustrations to your pages. You can add custom shapes, charts, graphs, infographics, and text boxes to your document with the built-in drawing tool.
Sketching with Google Docs
Although it is simple to add a graphic to your Google Docs, the procedure is not totally visible. Here’s how:
1 . Open a new document on Google Docs.
2 . Click on the insert button and select Drawing . Then, from the drop-down option, choose New to open the drawing screen.
3 . You can use the toolbox on this screen to add text boxes, select lines, and shapes, and modify the colors of your drawing.
4 . You may also use the cursor to adjust the size of your drawings and the color of your designs by using the toolbox at the top of your screen.
5 . When finished, click the Save and close button. You can click on the “File” toolbar displayed on the top of your screen to download your document.
|CLI? GUI? Online?||Online.|
|Requires an Account?||Yes, a Google account is required.|
|Collaborative Editing?||Yes, with Google Drive sharing.|
|Import SQL||Not Applicable.|
|Export SQL||Not Applicable.|
|Export Formats||.doc, .pdf, .rtf, .odt, .txt, .html, .epub|
|Generate Shareable URL||Yes.|
Google Docs offers amazing convenience. However, diagramming databases is not something it was intended for. You may find yourself frustrated with redrawing arrows and relationships if you are making frequent edits to your model.
Graphviz is a free graph visualization software that allows us to express information diagrammatically.
Graphviz implements the DOT language. The DOT language is an abstract grammar that makes use of terminals, non terminals, parentheses, square brackets, and vertical bars. More information about the DOT language can be found in its documentation.
Graphviz has an impressive and supportive community. However, a high level of SQL support is only available when you install additional third-party software. This overhead may make it less approachable to users that are not comfortable setting up their computer to support these tools.
ERDPlus is a database modeling tool that allows you to create Entity Relationship Diagrams, Relational Schemas, Star Schemas, and SQL DDL statements.
It includes a brief guide on how to create your ER diagrams, which is especially useful for beginners. You can also easily convert your created ER diagrams to relation schemas.
|CLI? GUI? Online?||Online.|
|Requires an Account?||Not required, but recommended for saving.|
|Collaborative Editing?||Not Applicable.|
|Export SQL||Yes, with the support of SQL DDL statements.|
|Generate Shareable URL||Not Applicable.|
ERDPlus is suited for SQL. It does lack additional export formats and ability to share with teams, but these features are not necessary with import and export.
Diagrams.net (previously Draw.io) is a free online diagramming tool that can be used to create flowcharts, UML diagrams, database models, and other types of diagrams.