Skip to content
Learnearn.uk » IB Computer Science » Entity Relationship Diagrams

Entity Relationship Diagrams

Introduction

Types of ERD

Entity-Relationship Diagrams (ERDs) provide a visual representation of the database structure.
They facilitate communication among stakeholders, guide the database design process, and serve as documentation for the database schema.

There are three types of Entity Relationship Diagrams – Conceptual, Logical & Physical.
As the project progresses and requirements became more defined the ERDs needed will move from Conceptual through to Physical.

 

Conceptual ERD

Conceptual ERD

Click to Enlarge

  • Focuses on high-level relationships between entities.
  • Used in the initial stages of database design to capture essential entities and their relationships.
  • Helps stakeholders understand the scope and requirements of the database system.

Used by

  • Business analysts
  • stakeholders
  • project managers

Logical ERD

Logical ERD

Click to enlarge

  • Used to translate the conceptual model into a relational database schema.
  • Specifies attributes for each entity, defines cardinality (one to one, one to many) and participation(optional vs required) constraints.
  • Provides a detailed view of the database schema, including primary and foreign keys.

Used by

Database designers, data architects, developers

Physical ERD

Physical ERD

Click to enlarge

  • Represents the actual implementation of the database on a specific DBMS in order to to build, optimize, and maintain the physical database schema.
  • Includes details such as data types, indexes, storage options, and constraints tailored to the chosen DBMS.

Used by

  • database administrators
  • system administrators
  • developers

Video

Types of ERD Diagram Videos

 

Resources