Skip to content

ER Diagram Maker

Saved

Arrow keys move between shapes. Enter or F2 edits the text, Tab adds the next step, Delete removes the shape. Alt plus arrow keys move it. Press Escape, then Tab, to leave the canvas.

Double-click to add Tab next step Space+drag to pan
ER Diagram templates, how-to guide & FAQs

ER Diagram Maker: Design database ERDs with tables, keys and crow's foot relationships

An entity relationship diagram (ERD) shows the tables of a database, their fields and keys, and how they relate one-to-one, one-to-many or many-to-many. Start from a library management system ER diagram, an ER diagram for a university database, or a hospital or pharmacy management system ER diagram, then edit the fields. Crow's foot and Chen notation are both supported.

5 ready-made templatesEditable PowerPoint exportPNG, SVG & PDFNo sign-up

ER Diagram templates

Click a template to open it in the editor above. Change any text, colour or shape, then download it.

How to make an ER diagram

Short on time?

  1. Start from an ERD

    Pick the library, university, hospital or pharmacy ER diagram, or start from a blank page.

  2. Edit tables and fields

    Double-click a table: the first line is its name, each next line is a field. Mark keys with PK and FK.

  3. Draw relationships

    Connect two tables and choose 1:1, 1:N or M:N; crow's foot ends are drawn for you.

  4. Share the model

    Export as editable PowerPoint, PNG, SVG or PDF for design reviews and documentation.

What you can do with it

Table shapes

Entity boxes with a header and one row per field, including PK and FK keys.

Crow's foot notation

One-to-one, one-to-many and many-to-many ends drawn correctly.

Chen notation

Entity rectangles, relationship diamonds and attribute ovals for teaching.

Editable export

Every table and connector stays editable in PowerPoint.

Frequently asked questions

What is the difference between a DFD and an ERD?

A DFD (data flow diagram) shows how data moves between processes, stores and external entities. An ERD shows how data is structured: the entities, their attributes and the relationships between them. Systems analysts often draw a DFD first and an ERD for the database behind it.

What entities are in a library management system ER diagram?

Typically Member, Book, BookCopy, Author, Loan and Fine. A member has many loans, each loan is for one book copy, and books and authors are many-to-many.

How do I show a many-to-many relationship?

Draw M:N between the two entities, or resolve it with a junction table, like Enrollment between Student and Course in the university database template.

What is the difference between crow's foot and Chen notation?

Crow's foot draws tables with their fields and marks cardinality at the line ends. Chen notation uses rectangles for entities, diamonds for relationships and ovals for attributes, and is common in textbooks.

What do diagrama ERD and ERD diagramme mean?

They are the Spanish/Portuguese and French/German ways of saying ERD diagram. The templates work in any language, just retype the labels.

Related diagram tools

Goes well with this — from our other free tools

Page updated .