DB1. ER Diagram

DB1. ER Diagram


An entity-relationship (ER) diagram, also called an entity-relationship model shows the connection between entities.

here are two kinds of ER diagrams: conceptual and physical.

Conceptual ER Diagrams

A conceptual ER diagram uses six standard symbols.

  1. Entities are objects or concepts that represent important data. Also known as strong entities or parent entities, these entities will often have weak entities that depend on them.

  2. Attributes are characteristics of an entity (i.e., many-to-many or one-to-one).

  3. Relationships are associations between entities.

  4. Weak entities depend on another entity.

  5. Multivalued attributes are attributes that can have more than one value.

  6. Weak relationships are the connections between a weak entity and its parent.

ER Diagram Notations

Physical ER Diagrams

Physical diagram models are more granular, showing the processes necessary for adding information to a database. Rather than using symbols, they consist of a series of tables.

Each entity is represented as a table, with each field acting as an attribute of the entity containing it.

Physical ER Diagram

Entities are connected via a system of notation called crow’s foot notation. The styling of the endpoint of each line distinguishes the relationship.

Crow's Foot Notation

The types of relationships in an ER diagram depend on the entity’s interactions with the other elements. Relationships can be one-to-one (1:1) or one-to-many (1:N). In some instances, the relationship will include many to many (N:N).