Identify the entities. The first step in making an ERD is to identify all of the entities you will use. … Identify relationships. Look at two entities, are they related? … Describe the relationship. How are the entities related? … Add attributes. … Complete the diagram.

How does an ERD look like?

Also known as ERDs or ER Models, they use a defined set of symbols such as rectangles, diamonds, ovals and connecting lines to depict the interconnectedness of entities, relationships and their attributes. They mirror grammatical structure, with entities as nouns and relationships as verbs.

What is an ERD in database design?

An entity relationship diagram (ERD), also known as an entity relationship model, is a graphical representation that depicts relationships among people, objects, places, concepts or events within an information technology (IT) system.