How to Create an ERD Diagram

Entity-relationship diagrams (ERD) follow the common three-schema approach to software engineering, with three levels of abstraction being used to define an ER model.

A conceptual data model is the most abstract view of a data model. It offers a complete overview of a business area, including all significant business entities, and describing their relationships. It omits further levels of detail, including data types and interface definitions, making it suitable as a means of presenting an initial business idea to a wide range of stakeholders.

Using Logical data model model a higher level of detail is established, with data entities describes as master, operational or transactional, and the relationships between them more precisely defined. This is the testing phase of a data model, where functionality can be observed independently of physical specifications.

When building a Physical data model, data modelers start to take into account the physical constraints of the database area. Important factors to consider are database performance, physical storage space, and indexing strategy. Diagram notations will fully define all tables and columns, indexes, constrain definitions, and any linking or partitioned tables.

The ability to describe a database using the Entity-Relationship model is delivered by the Entity-Relationship Diagram (ERD) solution. This solution extends ConceptDraw DIAGRAM with 2 libraries that contains 45 objects advocated by Chen's and Crow’s Foot notations that can be used when describing a database.

1. Run ConceptDraw ConceptDraw STORE by choosing the command Open Solutions in the Solution Park menu.
2. Open the Chen ERD, or the Crow's Foot ERD template from the ERD section.
3. Add objects to the diagram by dragging them from the Chen ERD, or the Crow's Fot ERD library to the document page.
4. Use Clone tool (Mac),(Win) to quickly add copies of the selected object.
5. Select the Smart Connector tool . To connect elements using this tool, drag the connector from one connect dot to another.
6. Use the Action button menu to change diagram elements. To open the menu select an object and click the  button in the upper rig ht corner of the object.


7. Use Line, Fill, Shadow and Text tools to format diagram objects.

Result: Entity-relationship diagram (ERD) represents a conceptual schema or semantic data model of a software system.