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 ERD shape libraries
Open the shape manager by pressing M on your keyboard. From there, simply select the “Entity Relationship” library, which includes standard ERD shapes and the ERD import/export.
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 code you need to translate your ERD into your DBMS. Simply click export, located below your entity relationship shapes, and select your preferred database system.