PINGDOM_CANARY_STRING
Lucidchart LogoHow to Draw an ER Diagram
    Build an ERD
Diagram

How to Draw an ER Diagram

What are your ERD needs?

I'm new to ERDs and want to learn more.
I want to make my own ERD in Lucidchart.

While ERDs may seem hard, they’re not as tricky as they appear. Entity-relationship diagrams can easily be built with the shapes included in a free Lucidchart account. Follow these steps to begin diagramming!

video placeholder

2 minute read

Want to make an ERD of your own? Try Lucidchart. It's quick, easy, and completely free.

Make an ERD

Identify the components

Entity-relationship diagrams are incredibly useful, and you can easily create one of your own by following these simple steps.

1. Determine the entities: Entities are typically nouns such as car, bank, student, or product.

In an ER Diagram, entities are the most important parts. To proceed, we will be creating a conceptual ER diagram of a simple system in which a student registers for a course that is taught by a professor. Check out this awesome tutorials to review ER Diagram Shapes. In this example, the three entities are “Student,” “Course,” and “Professor.”

ER Diagram Entity Shapes

2. Identify the relationships: Relationships highlight how entities interact with each other.

Relationships are typically verbs such as “buys,” “contains,” or “does.” In our example, the relationships “Registers for” and “Teaches” effectively explain the interactions between the three entities.

ER Diagram Relationship Shapes

3. Add attributes: Attributes show specific characteristics of an entity, refining what information is important to the model.

In an ER Diagram, attributes are necessary to model what characteristics will be included with each entity. Attributes such as “IDNumber,” “Name,” and “SKU” are common attributes.ER Diagram Attribute Shapes

4. Complete the diagram

Organizing the ERD in a logical way is incredibly important to increase comprehension. The main purpose of entity-relationship diagrams is to model a complex database, so learning how to create simple, logical ERDs is key.

How to create an ER Diagram

Lucidchart is a free tool that will allow you to diagram your database online and it's free when you register. Sign up is simple and you can start diagramming your databases immediately!

Enable ERD shape libraries

In a new document, make sure that the entity-relationship shapes libraries are enabled by clicking on the “+ Shapes” button found in the left menu.

ERD shape library

Drag and drop shapes

Once you have enabled the entity relationship shapes, add shapes to the canvas by clicking on the desired shape, and dropping it wherever you want it.

make an entity relationship diagram

Connect shapes

After placing the appropriate shapes on the canvas, connect the shapes by dragging out from the red dots at the borders of the shapes. Then, you can change the line ending in the toolbar above the canvas.

how to make an ERD

Additional Resources

  • Enhanced ER Diagram Tutorial
  • Entity-Relationship Diagram Symbols and Notation
  • What is an Entity Relationship Diagram (ERD)?

With the help of Lucidchart, creating professional-looking ERDs, data flows, and other specialized diagrams has never been easier. Since all editing takes place right in a web browser, collaborating and sharing is as simple as the press of a button. Sign up for a free account and check it out for yourself.

Want to make an ERD of your own? Try Lucidchart. It's quick, easy, and completely free.

English
EnglishFrançaisDeutsch日本語PortuguêsEspañolNederlandsPусскийItaliano
PrivacyLegal
© 2021 Lucid Software Inc.