Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

The Guide to Drawing an ERD (Entity Relationship Diagram) in Confluence & Jira

Here's the guide to building an ERD! We'll be using Gliffy Diagram for Confluence and Jira in the examples below, but feel free to use your diagram tool of choice. 👍

How to create an ERD2 GIF

What is an entity relationship diagram (ERD)?

ERDs are used for describing data and the rules determining how entities and attributes interact with each other. An Entity-Relationship diagram is hugely important in database design and should be the first thing you draw when contemplating database architecture. (For a more in-depth look as well as a description of commonly used ERD symbols and their meaning, check out this article.)

How to draw an ERD diagram

To get started creating your ERD, open up a new diagram and scroll down to “more shapes” in the library section.

 

How to create an ERD, step 1

 

Select Software Design, open up all the options by clicking the down arrow, then choose the Entity-Relationship symbols.

 

how to create an ERD, step 2

 

Step 1: Start by determining the entities that will make up your diagram. In the case of this cell phone purchase flow, the entities are: the customer, the type of phone, the bill, and the login.

 

how to create ERD, start with entities

 

Step 2: Next, determine the attributes (or variations) your entities will have. For the customer, we’ll need to know name, customer id, their phone number, where they live and the amount they need to pay. Go through each of your entities and determine what attributes they need to have.

 

how to draw an ERD, add the attributes

 

Pro Tip! To keep your diagram neat, space your entities and attributes out out evenly and color-code them. You can color code multiple shapes at a time by selecting them.

 

Step 3: Determine what kind of relationships govern the interaction between different entities. Plot them out.

 

how to create an ERD, adding relationships

 

Step 4: Decide whether the interactions will be one to one, one to many, many to one etc. and choose the appropriate connectors. You can either select the appropriate connector types from the shape library or choose the appropriate tip type once your shapes are joined.

 

How to ERD, connector tip types-1

Once your diagram is complete, you can decide to share it and ask for collaborators to leave comments, print it or publish it via a public link.

You've got this! Get out there and start diagramming 🙌

0 comments

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Staying organized with Jira: best practices for a better project management

Project managers know this problem: A “mountain of work” lays in front of you, and you don’t know how and where to tackle them. Different to-dos lie ahead, but just one task after the other can be ha...

334 views 2 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you