ER diagram tool
Lucidchart is a visual workspace that combines diagramming, data visualization, and collaboration to accelerate understanding and drive innovation.Watch the Video
How to draw ER diagrams online in Lucidchart
Enable the entity relationship shape library
Open the shape manager in Lucidchart and select the “Entity Relationship” library, which includes standard ERD symbols and our import/export feature to connect to your DBMS or Salesforce account.
Determine the entities from your database
Entities represent a table in your database. Depending on the subject of your diagram, your entity could be a customer, product, or even a physical location, like a bank.
Identify the relationships between entities
Relationships highlight how entities will interact with each other, if at all. Indicate entity relationships by drawing lines between them and then adding the appropriate cardinality on each end.
Add all necessary entity attributes
Attributes are the specific properties or traits of an entity that are important in your model, such as the first and last name of a customer entity. Add your attributes and the associated primary and foreign keys.
Export your ERD to the DBMS of your choice
Lucidchart automatically generates the SQL commands you need to match your ERD to your DBMS. Simply click the export featured link from your entity relationship shapes, select your DBMS, and follow the instructions for copying the generated commands and applying them to your database.