Language

Category

# Entity Relationship Diagrams : Theory & Models For Beginners

1.00 (1 reviews)

Students

Content

Last Update
Regular Price

## Topics

EXCLUSIVE SKILLSHARE OFFER
30-DAY FREE TRIAL

## 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

## Description

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 :

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 !

## Content

Introduction

What is a relational database ?

What to expect from this course ?

What is the entity relationship model ?

Entities & Attributes

Entities

Attributes

Entitites & Attributes Quiz

Relationship & Cardinalities - Part 1

Relationship & Cardinalities - Introduction

Relationship Roles

Participation

Recursive Relationships

Binary Relationships

Ternary Relationships

N-ary Relationships

Quiz Relationships & Cardinalities Part 1

Relationship & Cardinalities - Part 2

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

Notations

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

Foreign Key

Compound Key

Thank you !

## Reviews

A
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

## 5/2/2020

Course created date

## 4/18/2021

Course Indexed date
Bot
Course Submitted by