Database Engineering
  • Need of Database
  • Database and Database Management System
  • What is Relational Database Model ?
  • Installing Postgresql
    • Installing PostgreSQL on Linux
    • Installing PostgreSQL on Windows
    • Installing PostgreSQL on Mac
    • Postgres in Docker
  • What happens during the initial installation ?
    • Roles, Users & Groups
    • More examples on Roles
  • Sample Databases
    • DVD Rental Database
  • Querying Data
    • SELECT Query
    • Column Aliases
    • Order By
    • SELECT DISTINCT
    • DB-TASK-001
  • Filtering Data
    • WHERE ?
    • AND Operator
    • OR Operator
    • LIMIT
    • FETCH
    • IN
    • BETWEEN
    • LIKE
    • SIMILAR TO
    • IS NULL
    • ESCAPE
    • DB-TASK-002
  • Entity Relationship Diagram
    • What is an ER Diagram ?
    • Entity
    • Identifiers
    • Relationship
    • Attributes
    • Cardinality
    • Entity Relationship Diagram Tutorial
    • DB-TASK-003
  • Joins
    • Joins
    • Joins With Employee and Departments
  • Joins on E-Commerce
Powered by GitBook
On this page
  1. Entity Relationship Diagram

What is an ER Diagram ?

PreviousDB-TASK-002NextEntity

Last updated 5 months ago

An Entity Relationship (ER) Diagram is a type of flowchart that illustrates how "entities" such as peopl, objects or concepts relate to each other within a system. ER Diagrams are most often used to design or debug relational database in the fields of software engineering, business information system, education and research.

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.

ER diagrams are related to data structure diagrams (DSD), which focus on the relationships of elements within entities instead of relationships between entities themselves. ER diagrams also are often used in conjunction with data flow diagrams (DFD), which map out the flow of information for processes or systems.

Diagramming is quick and easy with , , . It's quick, easy and completely free.

📏 Note: Personal recommendation is

Mapping Natural Language

ER components can be equated to parts of speech.

  • Common Noun: Entity Type, Example: Student

  • Proper Noun: Entity, Example: Syed Jafer

  • Verb: Relationship Type, Example: Enrolls ( Such as in course, which would be another entity type )

  • Adjective: Attribute for entity, Example: Piano

  • Adverb: Attribute for relationship, Example: Digitally.

🥁 You might need to revisit this again at the end of this chapter.

Let us consider the example of University Management System.

draw.io
Lucidchart
smartdraw.com
draw.io.