Entity Relationship Diagrams : Theory & Models For Beginners

Learn how the entity relationship model works and make your own entity relationship diagram !

1.00 (1 reviews)


1 hour


Apr 2021

Last Update
Regular Price

Exclusive  SkillShare  Offer
Unlimited access to 30 000 Premium SkillShare courses

What you will learn

You will learn perfectly how an entity relationship diagram works.

You will confidently be able to build an entity relationship diagram.

You will learn how to understand all the notations : Chen, Crow Foot, Min/Max & More

You will understand how the cardinalities work and how entities are related to each other

You will learn about all the key attributes and their functions : Primary Key, Foreign Key, Super Key, Candidate Key, Natural Key & More

You will understand every single type of relationship : One to One, One to Many, Many to One, Many to Many, Zero to One, Zero to Many & More


Hello everyone and welcome to this class !

This course is exactly what you need in order to understand entity relationship diagrams.

So much information is available on the internet and it might be confusing.

Instead of spending too much time looking for it, you can get everything here !

The course has 6 main chapters :

  • Entities and attributes

You will understand the basic descriptions of entities and attributes and it is drawn on an entity relationship diagram.

Here are the subchapters :

  1. Entity

  2. Entity Type

  3. Entity Set

  4. Entity Type Representation

  5. Tables

  6. Attributes

  7. Single Valued Attributes

  8. Multi Valued Attributes

  9. Composite Attributes

  10. Derived Attributes

  11. Weak Entities

  • Relationships and cardinalities part 1

You will understand how relationships between entities work.

Here are the subchapters :

  1. What are relationships for ?

  2. Relationship roles

  3. Participation

  4. Recursive relationships

  5. Binary relationships

  6. Ternary relationships

  7. N-ary relationships

  • Relationships and cardinalities part 2

You will have a better understanding of how entities are related to each other.

Here are the subchapters :

  1. Business rules

  2. Cardinalities

  3. Zero To Zero Relationships

  4. Zero To One Relationships

  5. One To Zero Relationships

  6. Mandatory One To One Relationships

  7. Zero To Many Relationships

  8. One To Many Relationships

  9. Many To Zero Relationships

  10. Many To One Relationships

  11. Many To Many Relationships

  • Notations

You will understand all the notations that are used to make an entity relationship diagram.

Here are the subchapters :

  1. Chen's Notation

  2. Min/Max Notation

  3. Crow's Foot Notation

  4. IDEF1X Notation

  5. UML Notation

  6. Arrow Notation

  • Key Attributes

Key attributes are used the make the difference between two rows on a table.

They are extremely helpful to understand how servers proceed to retrieve the data.

Here are the subchapters :

  1. Primary Key

  2. Composite Primary Key

  3. Surrogate Key

  4. Alternate Key

  5. Candidate Key

  6. Natural Key

  7. Unique Key

  8. Foreign Key

  9. Compound Key

Please note that aside from these lectures, there are also 7 quizzes and 2 assignments.

Thank you and enjoy it !


Entity Relationship Diagrams : Theory & Models For Beginners
Entity Relationship Diagrams : Theory & Models For Beginners
Entity Relationship Diagrams : Theory & Models For Beginners
Entity Relationship Diagrams : Theory & Models For Beginners



What is a relational database ?

What to expect from this course ?

What is the entity relationship model ?

Entities & Attributes



Entitites & Attributes Quiz

Relationship & Cardinalities - Part 1

Relationship & Cardinalities - Introduction

Relationship Roles


Recursive Relationships

Binary Relationships

Ternary Relationships

N-ary Relationships

Quiz Relationships & Cardinalities Part 1

Relationship & Cardinalities - Part 2

Business Rules & Cardinalities Introduction

Zero To Zero Relationship

Zero To One Relationship

One To Zero Relationship

Mandatory One To One Relationship

One & Zero Relationship Quiz

Zero To Many Relationship

One To Many Relationship

Many To Zero Relationship

Many To One Relationship

Many To Many Relationship

Zero, One and Many Relationship Quiz


Chen's Notation

Chen's Notation : Participation

Chen's Notation Quiz

Min/Max Notation

Min/Max Notation Quiz

Crow's Foot Notation

Other Notations

IDEF1X Notation

UML Notation

Arrow Notation

Key Attributes

Primary Key

Composite Primary Key

Surrogate Key

Second or Alternate Key

Primary, Composite, Surrogate & Second Key

Super Key

Candidate Key

Natural, Business or Domain Key

Foreign Key

Compound Key

Thank you !


Alexandra21 May 2021

Rather a presentation than a course, and I am sorry to say it but I have to, quite a boring one. 1-minute slides with too much info, lack of additional explanations, at times too quick to follow, sounds shaky and not convincing. I could have just read the definitions anywhere online instead of wasting one hour to eventually get them presented as "course".


Udemy ID


Course created date


Course Indexed date
Course Submitted by