Entity Relationship Diagram (ERD) Tutorial - Part 1

Learn how to create an Entity Relationship Diagram in this tutorial. We provide a basic overview of ERDs and then gives step-by-step training on how to make an ER diagram with correct cardinality.
Entity Relationship Diagrams are comprised of 3 main categories: entities, attributes, and relationships. Entities are objects or concepts that are associated with important data-like a customer, order, or product. Attributes represent properties or traits of an entity, such as a customer’s phone number or home address. Relationships demonstrate the link between entities.
Another main aspect of of ERD's is cardinality, which further defines the relationship between entities in a numerical way. Certain symbols signify the minimum and maximum relationship between different entities.
--
00:00 Intro
0:25 What's an ERD?
1:05 How do we make an ERD?
1:25 Entities
1:54 Attributes
2:17 Relationships
2:47 Cardinalities
3:15 ERD examples
5:20 Putting it all together
--
Learn more at: training.lucid.co
Sign up for free at: www.lucid.co
Follow us:
Facebook: / lucidsoftware
Twitter: / lucidsoftware
Instagram: / lucidsoftware
LinkedIn: / lucidsoftware

[@lukeobot6796]

This tutorial is fantastic! Made much more sense than my college instructor!

[@StudywithmeinPakistan]

I am recommending this video to my students, because i find it useful and easy to understand. Big Thumbs up and Regards from Pakistan.

[@im.ayazkhan]

Present sir

[@pjguitar15]

I love tutorials with beautiful illustrations and animations. This content is high quality!

[@kiflomberihu630]

This channel is always the best for learning diagrams. Thank you a lot

[@kereamahohua4516]

Thank You for your time in putting this together… it’s very helpful 👌🏽

[@danurarya0823]

the min and max concept to apply some relationship between entity really help to understand, thanks

[@maximvassilev172]

Super simple and easy. Thanks !

[@bayandkheel4405]

Thank you so much! Interesting and clear!

[@mdyousufgazi4030]

thank you so much for this amazing video. its easy to understand and cleared my confusion regarding how to think

[@WaliSayed]

Amazing and interesting, the explanation and introduction of cardinality.

[@mmtanp]

Thank you very much for this clear and concise tutorial. It helped a lot.😊

[@luciferani8279]

You make it easier than my teacher did, thank you

[@camilotello3296]

I REALLY loved this one!!! Thank you SOOOO much

[@uncomaaRoxx]

nice and clear explain to understand of ERDs

[@winteriscoming4407]

Thank you Bear! your explanation was so clear for me as a freshly entered to this field. will definitely try the app soon!

[@luuu_na35]

It is easier than I thought, thanks!

[@praveenxyz123]

That was an excellent explanation, Good one!

[@hamzahassan436]

Thank you so much, I learned a lot from this!

[@rezaainulzaki9651]

Excellent explanation, thank you

[@codzilla90]

This has been explained to me 3 different times in 3 different ways, but today I still had the question come to mind, "wait, what's an ERD? ohhh.... right, that thing."
Bear, thanks to your explanation, I believe I'm now a guy who gets what an ERD is.

[@Kingoftheelectricity5485]

Wooooooo. Another lucidchart vid. I don’t even care that it isn’t animal related. You’re too iconic to not be enjoyed. Have a day as amazing as you’re content and I hope you get your old viewers back.

[@seobizhub9116]

Wow thank you!!! I just graduated from Udacity but couldn't understand the ER Diagram completely.

[@smart_allen1851]

this was very helpful. just followed and subscribed.

[@nickygood3342]

Wow, thank you :) YOU are amazing. I love Lucid Chart, sooooo cool.

[@havefun5519]

This video solves my confused. Thanks

[@omarshags]

This guy is the GOAT

[@vampirekabir8356]

nice and clear explain to understand of ERDs
thanks

[@cswithsaad]

absolutely marvelous. literally wow

[@manisarma3304]

what an awesome video. Simple and crisp

[@mirandaahearn5271]

This was great! Thank you

[@christopherchennat5750]

This is great! Thanks!!

[@joyariffic4217]

Omggg Bear!! That's such a cute and cuddly name! I love it

[@vm.odilbek]

Thank you very much for such understandable tutorial! I wish my lecturer in university could understand this in such way...

[@xiau]

Hope so😂

[@escobol]

thank you for this great tutorial

[@mohammednajeb3716]

Hope you explain component diagram, we would be so grateful ❤

[@joyaroha6683]

Thanks these are the best...

[@ahmedabdelzaher3274]

thank you man you helped me a lot

[@zakyoung2374]

Great video!

[@MrBoczald]

Awasome! Thank you

[@thenetworkguru3485]

Better than my database instruction manual

[@InfoLunix]

Awesome!

[@josephkarianjahi1467]

Thank you

[@DevEmpower]

Hi. Can I use Lucid website to design entities and other diagrams and show them on my Tutorials? I create Fullstack tutorials

[@warrenpatsi5156]

3:38 if a customer has zero orders then he seizes being a customer or how does this work

[@biomagician]

Hello and thank you for this great video. For the cardinality of the relationship between customers and orders, you say that a customer can have zero or many orders, and you use the corresponding sign (a zero followed by a crow's foot). However, would it not be more correct to say that a customer can have zero, one, or many orders? Is there a sign for that? Or does the zero/crow's foot sign encompass one order, and the cardinality signs only encompass minimum and maximum? If the latter is true, then it would be more correct to say that a customer can have between zero and many orders. Thanks!

[@ganyrehs]

Zero or many takes care of zero, one, or many.

[@iampoip]

tysm easier to understand than my teacher tech me

[@wyattbarton1744]

what if the minimum is more than 1?

[@minecaftlichking]

thanks

[@Kingoftheelectricity5485]

How much for an autograph from the guy who does the sneks videos

[@firey_solution]

dope video

[@CasualBiker]

Hi, can we create an ER diagram for a simple snake game created using Java? Or is the ER diagram applicable only for Database? Please suggest.

[@elalemanpaisa]

So a Product can only be sold once, we is there a quantity?

[@sohailkan17]

Hello, is it possible to use AI to create the diagram if all I give is the table and the details of the attributes?
I tried using Mermaid AI with GPT's assistance, but I am unable to see the database diagram-basically an ER diagram with columns and different types of key definitions there

[@ganyrehs]

You have to use logic and make sure relationships are correct. AI can only help explain to certain level.

[@fredrexsalac961]

But My table shows that the fifth table connects 4 tables to the column

[@GringaDoe]

I was like: wow just that??? Alright. Homework done

[@niteshshrestha4971]

thankyou man im from nepal

[@samirneupane7563]

me to

[@suthishofficial]

Anyone explain how a product comes without any orders and many orders for same product

[@Kashmiriboy.]

❤❤❤❤❤❤❤

[@nagababukasa2466]

Good

[@user-ko3xh5zj1x]

What's the difference between 1 and 1 and only 1?

[@ganyrehs]

1 and only 1 means it will always be one. 1 to 1 is the relationship between two entities.

[@mujahidansorimajid1524]

what is the difference between "one" and "one and only one"

[@KratosCY]

I wonder that too

[@bilalahmed4982]

Thank you you beautiful man i could kiss you right now for making this so simple

[@user-xb5ds5hh2k]

How can a product have no order now where is it going😢

[@sekharv4]

00:04 Learning about Entity Relationship Diagrams (ERDs)
00:50 ERDs provide a visual way to understand how information is related.
01:35 Entities are objects tracked in the database.
02:19 Entities and attributes have relationships defining interactions.
03:10 Understanding relationship and cardinality between customer and order.
03:51 ERD notation for minimum and maximum relationships
04:40 Understanding relationship cardinality in ER diagrams
05:26 Export ERD directly to database using Lucidchart

[@LaughingMan44]

There's no relationship between you product and order tables with the attributes you've listed.

[@JXSeaton]

@@moy3804 the order table has no product id. That and the relationship is wrong. it is a one to many relationship. Please don't try to learn database design from this company.

[@hazellincons7139]

i noticed it too, i thought you could only connect it if there's a foreign key which could be the product_id

[@siddy2456]

He would need a junction table between Order and Product “OrderProduct”. They didn’t want to go this deep I guess

[@LaughingMan44]

@@siddy2456 IMO it's not that deep, and makes it easier to understand

[@ewurafuaquansah_]

He talked about the primary and foreign keys in the part two of it

[@fleepy7985]

I WANT MORE CAUTION RAMEN!!!!!!!!!!!!!!!!!!!!!!

[@michaeljohnson3383]

Number of customers, not amount. Customer is a countable noun.

[@Markus-iq4sm]

So so

[@factsbymanii]

i think bro like crocs

[@3fast5you]

I am just trying to learn to make ERD's, I don't care for your lame attempts at jokes or cheap and out-of-place cultural references

[@simolive-wv7lf]

🫡respect

[@arjavjain5671]

what is bear's pronoun