Lucidchart is the leading ER diagram tool. Entity-relationship diagrams (ERD) are essential to modeling anything from simple to complex databases, but the shapes and notations used can be very confusing. This guide will help you to become an expert in ER diagram notation, and you will be well on your way to model your own database! 4 minute read Want to make an ERD of your own? Try Lucidchart. It's quick, easy, and completely free. Conceptual Data Models establish a broad view of what should be included in the model set. Conceptual ERDs can be used as the foundation for logical data models. They may also be used to form commonality relationships between ER models as a basis for data model integration. All of the symbols shown below are found in the UML Entity Relationship and Entity Relationship shape library of Lucidchart. ERD entity symbolsEntities are objects or concepts that represent important data. Entities are typically nouns such as product, customer, location, or promotion. There are three types of entities commonly used in entity relationship diagrams.
ERD relationship symbolsWithin entity-relationship diagrams, relationships are used to document the interaction between two entities. Relationships are usually verbs such as assign, associate, or track and provide useful information that could not be discerned with just the entity types.
ERD attribute symbolsERD attributes are characteristics of the entity that help users to better understand the database. Attributes are included to include details of the various entities that are highlighted in a conceptual ER diagram.
Diagramming is quick and easy with Lucidchart. Start a free trial today to start creating and collaborating. Make an ERDThe physical data model is the most granular level of entity-relationship diagrams, and represents the process of adding information to the database. Physical ER models show all table structures, including column name, column data type, column constraints, primary key, foreign key, and relationships between tables. As shown below, tables are another way of representing entities. The key parts of Entity-relationship Tables are: FieldsFields represent the portion of a table that establish the attributes of the entity. Attributes are typically thought of as columns in the database that the ERD models. In the image above, InterestRate and LoanAmount are both attributes of the entity that are contained as fields. KeysKeys are one way to categorize attributes. ER diagrams help users to model their databases by using various tables that ensure that the database is organized, efficient, and fast. Keys are used to link various tables in a database to each other in the most efficient way possible. Primary KeysPrimary keys are an attribute or combination of attributes that uniquely identifies one and only one instance of an entity. Foreign KeysForeign keys are created any time an attribute relates to another entity in a one-to-one or one-to-many relationship. Each car can only be financed by one bank, therefore the primary key BankId from the Bank table is used as the foreign key FinancedBy in the Car table. This BankID is able to be used as the foreign key for multiple cars. TypesTypes refer to the type of data in the corresponding field in a table. Types can also refer to entity types, which describe the composition of an entity; e.g., a book's entity types are author, title, and published date. While crow's foot notation is often recognized as the most intuitive style, some use OMT, IDEF, Bachman, or UML notation, according to their preferences. Crow's foot notation, however, has an intuitive graphic format, making it the preferred ERD notation for Lucidchart. Consider using one of our Crow Foot ER Diagram templates. Cardinality and ordinalityCardinality refers to the maximum number of times an instance in one entity can relate to instances of another entity. Ordinality, on the other hand, is the minimum number of times an instance in one entity can be associated with an instance in the related entity. Cardinality and ordinality are shown by the styling of a line and its endpoint, according to the chosen notation style. Building powerful ER diagrams has never been so quick and easy with Lucidchart. With every standard entity-relationship shape available on Lucidchart and all editing taking place on the cloud, collaborating with co-workers, teammates, supervisors, and professors is incredibly easy. Want to make an ERD of your own? Try Lucidchart. It's quick, easy, and completely free. |